Link to home
Start Free TrialLog in
Avatar of Mushfique Khan
Mushfique Khan

asked on

Oracle Role Definitions + Privileges

Hi, how I can extract all the role names & privileges, is there any way/script or oracle support doc, you are aware of.

Oracle: 11203

Do share, thanks in advance.
Avatar of johnsone
johnsone
Flag of United States of America image

Role names are stored in DBA_ROLES.

You can extract the privileges from DBA_TAB_PRIVS and DBA_SYS_PRIVS to determine what is granted to the role and then DBA_ROLE_PRIVS to determine what users (or roles) are granted the role.
Avatar of Mushfique Khan
Mushfique Khan

ASKER

thanks johnsone, but this I'm aware too, looking for some sql or script to generate a file, which can be run on any other db to copy the roles/privileges too.
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks johnsone, kind of struggling, can you please assist a little more here, how to extract for a specific/one role?

Much appreciated.
What have you tried?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks a lot, let me test/verify, will get back soon.