Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select access on all tables?
D. Alvarado wrote:
> 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
Use SQL to write SQL.
Each table must be granted individually.
Or use a ROLE.
Received on Sun Dec 14 2003 - 21:19:10 CST