How To Check the Grants on a User

Run this query in SQL Developer. You’ll be prompted for the user when you run the query. Alternatively run the query in sqlplus but substitute a string in place of :the_user variable.

1
2
3
4
5
6
7
SELECT GRANTEE, PRIVILEGE
    FROM sys.dba_sys_privs
    WHERE grantee = :the_user
UNION
SELECT GRANTEE, PRIVILEGE
    FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)
    WHERE rp.grantee = :the_user;