How can you check which user has which Role.

  • Interview Candidate
  • 6
  • 2608

Showing Answers 1 - 6 of 6 Answers

amit

  • Jul 15th, 2005
 

desc dba_tab_privs

  Was this answer useful?  Yes

Shrikant Pande

  • Aug 24th, 2005
 

Can use ROLE_TAB_PRIVS also

  Was this answer useful?  Yes

jackliu00

  • Jan 15th, 2006
 

select * from dba_role_privs order by grantee;

Govind

  • Jun 3rd, 2006
 

SELECT A.ROLE,
A.PRIVILEGE
FROM ROLE_SYS_PRIVS A,
DBA_ROLE_PRIVS B
WHERE A.ROLE=B.GRANTED_ROLE AND
B.GRANTEE='SCOTT'
UNION
SELECT null role, A.PRIVILEGE
FROM dba_sys_privs a
WHERE a.grantee = 'SCOTT'

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions