← 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