Home » RDBMS Server » Security » ROLE - PRIV mapping
ROLE - PRIV mapping [message #267246] Wed, 12 September 2007 16:40 Go to next message
srp_appsdba
Messages: 3
Registered: September 2007
Junior Member
Hi

One user has 20 roles in my Dev schema , when I check from DBA_ROLE_PRIVS.
I want to create the same roles in TEST schema. How do I find the privileges associated with each role.
Mapping between (ROLE - PRIVS ). I couldn't find the table naem.
I need the defnition to create the same roles in my TEST schema
Re: ROLE - PRIV mapping [message #267251 is a reply to message #267246] Wed, 12 September 2007 18:32 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
role_tab_privs
role_sys_privs
role_role_privs

SQL> SELECT  dbms_metadata.get_granted_ddl('SYSTEM_GRANT','RESOURCE') from dual;

DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','RESOURCE')
--------------------------------------------------------------------------------

  GRANT CREATE INDEXTYPE TO "RESOURCE"

  GRANT CREATE OPERATOR TO "RESOURCE"


SQL>

[Updated on: Wed, 12 September 2007 18:35]

Report message to a moderator

Previous Topic: Default Account Management
Next Topic: Change of password
Goto Forum:
  


Current Time: Fri Mar 29 09:54:55 CDT 2024