Re: Grant on all in user's schema

set feedback off
set pagesize 0
set lin 256
spool xxx.sql
select 'grant select on USER.'||table_name||' to ROLE;' from dba_tables where owner = 'USER2';
spool off

then run xxx.sql

kirill_at_cs.ualberta.ca (Kirill Richine) wrote:

>Hi!
 

>I was wondering if there was a way to grant a privilege on all the
>tables in the user's schema to some other user.
 

>I am trying to do:
 

>create role ROLE
>/
>grant select on
> (select table_name from sys.dba_tables where owner = 'USER')
> to ROLE
>/
 

>but it does not work because (select... 'USER') is not a valid table
>name.
 

>Thank you.
>k&
Received on Wed Jun 05 1996 - 00:00:00 CEST