Archives of the TeradataForum
Message Posted: Tue, 26 Jun 2001 @ 17:21:37 GMT
<-- Anonymously Posted: Tuesday, June 26, 2001 11:40 -- >
I archived macros from database CORPVMP1 and was restoring them to CORPVMDR. The macros go against views but the database is not hard- coded in the macros, so I thought when I restored the macros to CORPVMDR, then macros would go against the views I had created in CORPVMDR.
This is how I restored the macros.
COPY DATA TABLES (CORPVMDR) ( FROM (CORPVMP1) ) A sample macro (database is not hard-coded): REPLACE MACRO KDCT11P3 AS (SELECT 'T074T000' (CHAR(8)), COUNT(*), 'RECORD COUNT FOR CDISWKLST' (CHAR(100)) FROM CDISWKLSTV1 ;
But when I execute the macro
I receive the error
Failure 3523 An owner referenced by user does not have SELECT WITH GRANT OPTION access to CORPVMP1.CDISWKLSTV1.
Therefore the macros on CORPVMDR seem to have a reference to CORPVMP1 embedded in them. The manual says that when you execute a COPY statement, partial names are fully qualified to the default database name. But my default database for the id I used for the COPY is another database.
Someone please enlighten me as to what is going on!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|