Home » RDBMS Server » Server Administration » Roles (oracle 9i on solaris 10)
icon9.gif  Roles [message #292600] Wed, 09 January 2008 05:53 Go to next message
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
Re: Roles [message #292603 is a reply to message #292600] Wed, 09 January 2008 06:02 Go to previous message
Frank Naude
Messages: 4516
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;

Previous Topic: Database consolidation
Next Topic: import sql database to Oracle database
Goto Forum:

Current Time: Sat Aug 19 23:16:56 CDT 2017

Total time taken to generate the page: 0.24007 seconds