Role-Based View or Materialized View Permissions

Grant permissions on a view or materialized view to a user, user-extended role, or standalone role.

• About the User or Role View Permissions List
  The Views 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 View Permission List
  Before revoking a grantee's permission, you need to identify grantees directly or indirectly granted the permission from the original grantee.
• Adding View or Materialized View Permissions to a User or Role
  Add permissions on a view or materialized view to a user, user-extended role, or standalone role.
• Removing View or Materialized View Permissions from a User or Role
  Remove permissions from a view or materialized view to a user, user-extended role, or standalone role.
• Removing Administrative Rights Only on a View or Materialized 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 view or materialized view.
• Adding Administrative Rights to a Granted View Permission to a User or Role
  Add administrative rights only to a granted view or materialized view permission.