Re: select access on all tables?

Do you mean

SQL > select 'grant select on ' || table_name || ' to scott;' from user_tables;

???

D. Alvarado schrieb:
> Hello,
> How do you grant select access on all tables in a schema to a
> particular user? I am using Oracle 8.1.7 on Solaris.
>
> Much thanks, Dave
Received on Sun Dec 14 2003 - 22:37:13 CST