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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l