Oracle: Find Object Grants

* Contains object grants for which the current user is the
– object owner,
– grantor,
– or grantee.

* Contains object grants
– all object grants from user_tab_privs
– Plus object grants for which an enabled role or PUBLIC is the grantee, i.e. object grants via role or PUBLIC.

* Contains all object grants in the entire database

* Find All Tables Granted to A User

SELECT * FROM dba_tab_privs WHERE grantee='A_USER';

* Find Tables Granted to Another User
– Login grantor schema

SELECT grantee, TABLE_NAME
FROM user_tab_privs
WHERE grantee = 'ANOTHER_USER';
 
SELECT grantee, TABLE_NAME
FROM all_tab_privs
WHERE grantee = 'ANOTHER_USER';

* Contains system privileges granted to users and roles.
* This view does not display the USERNAME column

* Contains system privileges granted to the current user.
* This view does not display the GRANTEE column,
* This view instead displays the USERNAME column.

* Contains roles granted to all users and roles in the database.

* Contains roles granted to the current user.