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

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 9 May 2005 15:21:23 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA65027C10DA@25exch1.vicorpower.vicr.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Monday, May 09, 2005 3:16 PM
To: oracle-l_at_freelists.org
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

Received on Mon May 09 2005 - 15:26:12 CDT