What kind of Oracle statement will list all roles and users

What kind of Oracle statement will list all roles and users (without repetition) who have access to a particular table?

Solution

SELECT DISTINCT A.GRANTED_ROLE,B.GRANTEE FROM DBA_ROLE_PRIVS A, DBA_TAB_PRIVS B
WHERE
A.GRANTEE=B.GRANTEE
AND B.TABLE_NAME=\'tablename\';


-------------------------------------------------------------------------------------------

What kind of Oracle statement will list all roles and users (without repetition) who have access to a particular table?SolutionSELECT DISTINCT A.GRANTED_ROLE,B.

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site