Following the User or Group Table Permissions Grant Trail

Before revoking a grantee's permission, you need to identify grantees directly or indirectly granted the permission from the original grantee.

The grant chain traces how a grantee has in turn granted a permission to other grantees.

However, when you view the object permissions granted to a specific user, or group, you only see the permissions granted to the selected user or group. You do not see who the user or group has granted the permissions to.

To determine who the selected user or group has in turn granted an object permission to, note the table, column name (if applicable), and the permission to be traced, then display the permissions list for the table object to be tranced. See Setting Table Permissions > Following the Table Permissions Grant Trail for details.

Related concepts
About the User or Group Table Permissions List
Following the Table Permissions Grant Trail
Related tasks
Adding Permissions on a Table or Column to a User or Group
Removing Permissions on a Table or Column from a User or Group
Adding Administrative Rights on a Granted Table or Column Permission to a User or Group
Removing Administrative Rights Only on a Table or Column Permission from a User or Group