View Permissions Privilege Summary

A list of the system privileges and object permissions required to complete the various view permission tasks.

Grant and Revoke Permissions on a View

Database Version Database Object Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • Administrative rights over the permission.
  • You own the database object.
SAP Sybase IQ Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You have administrative rights (with grant option) to the permission.
  • You own the database object.

Adjust Administration Permissions on a View

Database Version Database Object Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the database object.
SAP Sybase IQ 16.0 Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You have administrative rights to the permission being modified.
  • You own the database object.
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group