Try :
Select 'grant '||privilege||' on '||owner||'.'||table_name||' to
'||grantee||';'
From dba_tab_privs
Where grantee =3D upper('&grantee');=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Monday, May 09, 2005 3:16 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: [Q] way to re-gernerate ROLE privilege ?
We have a ORACLE role with 50 different object
privileges grant to it. Does there has way to
generate a script which I can bring this script to
another database and re-create it?
Thanks.
=09
__________________________________=20
Do you Yahoo!?=20
Yahoo! Mail - Helps protect you from nasty viruses.=20
http://promotions.yahoo.com/new_mail
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l