Archives of the TeradataForum
Message Posted: Tue, 14 Apr 2009 @ 13:26:14 GMT
| Subj: || || Macro Error 3523 : A owner referenced by user |
| From: || || Kota, Soujanya |
When I am executing the below macro ,I am getting an error.
REPLACE MACRO SAMPLES.table_info
SELECT tablename FROM dbc.tables where databasename='samples' ;
Error : 3523 : A owner referenced by user does not have SELECT WITH GRANT OPTION ACCESS
i gave the below permissions..but still it is not working:
GRANT SELECT ON SAMPLES TO dbc WITH GRANT OPTION.
Can anyone please help.