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 You must have one of:
  • DBA authority
  • PERMS ADMIN authority
  • Administrative rights over the permission
  • You own the database object
SAP Sybase IQ You must have 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 You must have one of:
  • DBA authority
  • PERMS ADMIN authority
  • You own the database object
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege
  • You have administrative rights to the permission being modified
  • You own the database object