Archives of the TeradataForum
Message Posted: Tue, 26 Jun 2001 @ 17:38:36 GMT
Others who know more about this will undoubtedly want to weigh in, but I notice two things that may be useful to you.
1. Macro definitions are stored in the Data Dictionary, not in the database. Did you restore the Dictionary at the same time as the tables? If not, that could be part of the problem.
2. Here's a little tip I wrote up to help with that 3523 error.
The most annoying message of them all is 3523, "An owner referenced by user does not have SELECT WITH GRANT OPTION access to databasename.tablename".
This usually happens when a database of views does not have access to another database (of tables). If a user gets this message, run the following command:
where db_in_msg is the database named in the message and db_of_views is the database of views that the user was trying to read from.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|