OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Roles (oracle 9i on solaris 10)

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

Roles [message #292600]

Wed, 09 January 2008 05:53

thorin666
Messages: 144
Registered: March 2007

Senior Member

Too many months ago, i created few roles to some users
some where admins grants, and others were dml's grants
now i must to reply that grants in other databases but i dont remember what grant had each role.
i was searching some views like role_role_privs, role_sys_privs and dba_role_privs but i cant find a description of that roles.
Can someone have an idea about where i must to search?
thnx in advance Wink

Report message to a moderator

Re: Roles [message #292603 is a reply to message #292600]

Wed, 09 January 2008 06:02

Frank Naude
Messages: 4593
Registered: April 1998

Senior Member

Try something like this:

SELECT dbms_metadata.get_ddl('ROLE', role) FROM dba_roles;

SELECT dbms_metadata.get_granted_ddl('ROLE_GRANT',  'your_role_name') FROM DUAL;
SELECT dbms_metadata.get_granted_ddl('SYSTEM_GRANT','your_role_name') FROM DUAL;
SELECT dbms_metadata.get_granted_ddl('OBJECT_GRANT','your_role_name') FROM DUAL;

Report message to a moderator

Previous Topic:	10 g parameter
Next Topic:	import sql database to Oracle database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 22:54:10 CST 2025