View Privilege Summary

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

Creating a View

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority
  • RESOURCE authority with SELECT permission on the tables in the view definition to create a view owned by you.
SAP Sybase IQ 16.0 View to be owned by self –
  • Requires CREATE VIEW system privilege.
  • Also requires one of:
    • SELECT ANY TABLE system privilege.
    • SELECT object permission on the underlying tables of the view.
View to be owned by any user – Requires one of:
  • CREATE ANY VIEW system privilege.
  • CREATE ANY OBJECT system privilege.
  • Also requires one of:
    • SELECT object permission on the underlying tables of the view.
    • SELECT ANY TABLE system privilege.

Viewing View Data in the Execute SQL Window

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4

None required. Query executes with user's current permissions.

SAP Sybase IQ 16.0

None required. Query executes with user's current permissions.

Recompiling and Enabling a View

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • All of these:
    • SELECT permission on the underlying tables of the view.
    • You own the view.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY VIEW system privilege.
  • ALTER ANY OBJECT system privilege.
  • You own the view.
  • Also require one of:
    • SELECT ANY TABLE system privilege.
    • SELECT permission on the underlying tables of the view.

Disabling a View

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • You own the view.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY VIEW system privilege.
  • ALTER ANY OBJECT system privilege.
  • You own the view.

Deleting a View

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • You own the view.
SAP Sybase IQ 16.0 Requires one of:
  • DROP ANY VIEW system privilege.
  • DROP ANY OBJECT system privilege.
  • You own the view.

Generating View DDL Commands

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.

Viewing or Modifying View Properties

Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4

View any view property page – None required.

Modify view permissions – Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • Administrative rights over the permission.
  • You own the database object.
Modify any other view property except those relating to triggers – Requires one of:
  • DBA authority.
  • You own the view.
For privileges relating to triggers, see:
SAP Sybase IQ 16.0

View any view property page – None required.

Modify view permissions – Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You have administrative rights (with grant option) to the permission.
  • You own the database object.
Modify a view comment – Requires any one of:
  • CREATE ANY VIEW system privilege.
  • CREATE ANY OBJECT system privilege.
  • ALTER ANY VIEW system privilege.
  • ALTER ANY OBJECT system privilege.
  • COMMENT ANY OBJECT system privilege.
  • You own the view.
Modify any other view property, except those relating to triggers – Requires one of:
  • ALTER ANY VIEW system privilege.
  • ALTER ANY OBJECT system privilege.
  • You own the view.
For privileges relating to view triggers, see:
Parent topic: Configuring SAP Sybase IQ for Administration
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