Role-Based Table or Column Permissions

Permissions on tables and columns can be granted and revoked to role-based users and roles, with or without administrative rights.

• About the User or Role Table Permissions List
  The Tables permissions list displays permission details the tables and column directly granted to a user, user-extended role, or standalone role
• Following the User or Role 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.
• Removing Permissions on a Table or Column from a User or Role
  Remove permissions on a table or column from a user, user-extended role, or standalone role.
• Adding Permissions on a Table or Column to a User or Role
  Add permissions on a table or column to a user, user-extended role, or standalone role.
• Adding Administrative Rights on a Granted Table or Column Permission to a User or Role
  Add user or role administrative rights only to a granted table or column permission.
• Removing Administrative Rights Only on a Table or Column Permission from a User or Role
  Remove administrative rights only from a permission granted to a user, user-extended role, or standalone role, on a table or column.