Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] How to recreate the role?

Re: [Q] How to recreate the role?

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 08 May 2006 18:54:05 +0200
Message-ID: <445F77AD.8020206@inter.net.il>


dba1 mcc wrote:

> 1. recreate "role"?
>
> 2. recreate "grant role" script?

You have not said what version.
Anyway in 9.2.0.6:

Use: select dbms_metadata.get_ddl('ROLE','role name') from dual to get the role ddl.
Use: select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','user name') from dual
to get the system grants
and: select dbms_metadata.get_granted_ddl('ROLE_GRANT','user name') from dual
to get the roles that are granted to user.

Adar Yechiel
Rechovot, Israel

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 08 2006 - 11:54:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US