Re: select access on all tables?

Roles are always more flexible than direct grants. But if you do it with roles, keep in mind that these tables would still not be visible from PL/SQL for this user (and any other user running that code, if definer rights was used).

Daniel

> 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 Mon Dec 15 2003 - 09:52:11 CST