Home » SQL & PL/SQL » SQL & PL/SQL » ddl for a role Plus role privs/grants (10.2.0.3)
ddl for a role Plus role privs/grants [message #311350] Fri, 04 April 2008 04:02 Go to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
How do you export/copy/extract a role from one database to another.

I know you can use dbms_metadata.get_ddl for getting the role definition. How do you get the grants and privileges assigned to the role. Do you have to create a script by querying the role_sys_privs,role_role_privs,role_table_privs ....

What method can you use to copy a role to another database.

Your help will be appreciated.
Re: ddl for a role Plus role privs/grants [message #311353 is a reply to message #311350] Fri, 04 April 2008 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select ... from ... where grantee='your role';
Where is the problem?

This is NOT an expert question.

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them.

Regards
Michel

[Updated on: Fri, 04 April 2008 04:20]

Report message to a moderator

Re: ddl for a role Plus role privs/grants [message #311856 is a reply to message #311353] Mon, 07 April 2008 02:51 Go to previous message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
Thanks, i will apply the rules next time.
Previous Topic: How to see/check the null records for this update statement; getting ORA-01407 error ?
Next Topic: Last line truncated
Goto Forum:
  


Current Time: Thu Dec 08 04:24:35 CST 2016

Total time taken to generate the page: 0.14968 seconds