Re: [Q] way to re-gernerate ROLE privilege ?

Sure. Generate SQL from SQL; something like:

set pages 0 feedb off trimspool on

select 'grant '||privilege||' on '||owner||'.'||table_name||' to '||grantee= ||';'
from all_tab_privs_made where grantee =3D <role>

spool grantrole.sql
/
spool off

Then run grantrole.sql on the other database.

--=20
Paul Baumgartel
paul.baumgartel_at_gmail.com

On 5/9/05, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> 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?
>=20
> Thanks.
>=20
>=20
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l