View Privilege Summary

Creating a View

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have 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 – you must have the CREATE VIEW system privilege. You must also have one of: SELECT ANY TABLE system privilege SELECT object permission on the underlying tables of the view View to be owned by any user – you must have one of: CREATE ANY VIEW system privilege CREATE ANY OBJECT system privilege You must also have one of: SELECT object permission on the underlying tables of the view SELECT ANY TABLE system privilege

Database Version

View Privileges

SAP Sybase IQ 15.3 and 15.4

You must have 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 – you must have the CREATE VIEW system privilege. You must also have one of:

SELECT ANY TABLE system privilege
SELECT object permission on the underlying tables of the view

View to be owned by any user – you must have one of:

CREATE ANY VIEW system privilege
CREATE ANY OBJECT system privilege

You must also have 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. Queries execute with the user's current permissions.
SAP Sybase IQ 16.0	None. Queries execute with the user's current permissions.

Recompiling and Enabling a View

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the view and have SELECT permission on the underlying tables of the view
SAP Sybase IQ 16.0	You must have one of: ALTER ANY VIEW system privilege ALTER ANY OBJECT system privilege You own the view You must also have one of: SELECT ANY TABLE system privilege SELECT permission on the underlying tables of the view

Database Version

View Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
You own the view and have SELECT permission on the underlying tables of the view

SAP Sybase IQ 16.0

You must have one of:

ALTER ANY VIEW system privilege
ALTER ANY OBJECT system privilege
You own the view

You must also have 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	You must have one of: DBA authority You own the view
SAP Sybase IQ 16.0	You must have 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	You must have one of: DBA authority You own the view
SAP Sybase IQ 16.0	You must have 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.
SAP Sybase IQ 16.0	None.

Viewing or Modifying View Properties

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	View any view property page – none. Modify view permissions – You must have 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 – you must have one of: DBA authority You own the view For privileges relating to triggers, see: View Trigger Privilege Summary
SAP Sybase IQ 16.0	View any view property page – none. Modify view permissions – 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 Modify a view comment – you must have 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 – you must have one of: ALTER ANY VIEW system privilege ALTER ANY OBJECT system privilege You own the view For privileges relating to view triggers, see: View Trigger Privilege Summary

Database Version

View Privileges

SAP Sybase IQ 15.3 and 15.4

View any view property page – none.

Modify view permissions – You must have 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 – you must have one of:

DBA authority
You own the view

For privileges relating to triggers, see:

View Trigger Privilege Summary

SAP Sybase IQ 16.0

View any view property page – none.

Modify view permissions – 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

Modify a view comment – you must have 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 – you must have one of:

ALTER ANY VIEW system privilege
ALTER ANY OBJECT system privilege
You own the view

For privileges relating to view triggers, see:

View Trigger Privilege Summary