OraFAQ Forum: Security » Privileges granted to role

Home » RDBMS Server » Security » Privileges granted to role (10.2.0.2.0 ,windows)

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

Privileges granted to role [message #430412]

Tue, 10 November 2009 06:04

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,

Report message to a moderator