OraFAQ Forum: Security » ROLE

Home » RDBMS Server » Security » ROLE - PRIV mapping

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ROLE - PRIV mapping [message #267246]

Wed, 12 September 2007 16:40

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

Report message to a moderator

Re: ROLE - PRIV mapping [message #267251 is a reply to message #267246]

Wed, 12 September 2007 18:32

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:27:13 CST 2024