Home » RDBMS Server » Security » Privileges granted to role (10.2.0.2.0 ,windows)
Privileges granted to role [message #430412] Tue, 10 November 2009 06:04 Go to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member
Hi,

To check the privileges granted to role,i used the below query but both were
giving different outputs.So which one to believe?

Please advice.

select grantee, privilege, admin_option from dba_sys_privs where grantee='ROLE1'

SELECT DISTINCT grantee,privilege FROM dba_tab_privs WHERE grantee ='ROLE1';


Regards,
Re: Privileges granted to role [message #430415 is a reply to message #430412] Tue, 10 November 2009 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Both! and you can add dba_role_privs and dba_col_privs.

Regards
Michel
Re: Privileges granted to role [message #430465 is a reply to message #430415] Tue, 10 November 2009 08:46 Go to previous message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member



Thank you
Previous Topic: Creating User With same Privilages as Existing User
Next Topic: Performance Issue with Virtual Private Database
Goto Forum:
  


Current Time: Mon Sep 22 13:20:43 CDT 2014

Total time taken to generate the page: 0.11409 seconds