Archives of the TeradataForum

Message Posted: Tue, 26 Jun 2001 @ 17:21:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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

EXEC CORPVMDR.KDCT11P3

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!

	<Prev	Next>		<<First	<Prev	Next>	Last>>