Authority-Based View or Materialized View Permissions

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

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