Authority-Based Table and Column Permissions

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

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