Re: How to grant select privilages to all tables in another schema without granting "select any table to..."

Mark wrote:

> How can I grant, for example, select privilages to a user on all tables or
> other objects that exist in another schema. However, I do not want to grant
> select permission to tables residing in other schemas that exist in the
> database. How can I enable this access without writing grant statements for
> each object in the schema in question?
>
> Thank you ahead of time,
> Mark

Why did you feel compelled to ask the exact same question twice using different verbiage within a four minute period?

The answer is the same ... you can not.

The solution is to write a small anonymous block or stored procedure to perform the assignments based on the table_name column in user_tables.

Daniel Morgan Received on Thu May 09 2002 - 14:45:13 CDT