← Users & Privileges
Oracle · Users & Privileges
How to check object (table) privileges in Oracle
List the object and table privileges granted to an Oracle user, with grantor and whether the grant is grantable.
Tested on11g12c19c21c23ai26ai
Object and table privileges granted directly to a user, with the grantor and whether the grant can be passed on. Privileges inherited through roles are covered by the full privilege script. Prompts for a username.
SELECT owner,
table_name,
privilege,
grantable,
grantor
FROM dba_tab_privs
WHERE grantee = UPPER('&&username')
ORDER BY owner, table_name, privilege;privilegesdba_tab_privsobject-privileges