OraFAQ Forum: SQL & PL/SQL » ddl for a role Plus role privs/grants

Home » SQL & PL/SQL » SQL & PL/SQL » ddl for a role Plus role privs/grants (10.2.0.3)

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

ddl for a role Plus role privs/grants [message #311350]

Fri, 04 April 2008 04:02

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.

Report message to a moderator

Re: ddl for a role Plus role privs/grants [message #311353 is a reply to message #311350]

Fri, 04 April 2008 04:20

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

mwansalovewell
Messages: 71
Registered: October 2007
Location: uk

Member

Thanks, i will apply the rules next time.

Report message to a moderator

Previous Topic:	How to see/check the null records for this update statement; getting ORA-01407 error ?
Next Topic:	Last line truncated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:30:38 CST 2025