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

Hi,

What you can do is generate a select Like this.

Spool Grants.sql
Select 'Grant Select on ' || Table_Name || ' to scott;' from User_tables. Spool off

@grants.sql

HTH

--
Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================
"Mark" <mzquincey_at_hotmail.com> wrote in message
news:EWzC8.201$QN7.6095133_at_newssvr17.news.prodigy.com...


> 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

>

>

>

>