Grant on all in user's schema
From: Kirill Richine <kirill_at_cs.ualberta.ca>
Date: 1996/06/04
Message-ID: <4p27t7$877_at_scapa.cs.ualberta.ca>#1/1
Date: 1996/06/04
Message-ID: <4p27t7$877_at_scapa.cs.ualberta.ca>#1/1
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 Tue Jun 04 1996 - 00:00:00 CEST