Archives of the TeradataForum

Message Posted: Tue, 26 Jun 2001 @ 17:38:36 GMT

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

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:

grant select
on db_in_msg
to db_of_views
with grant option;

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.

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