View Privilege Summary

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.

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.

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.

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.

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.

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.

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

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: View Trigger Privilege Summary
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: View Trigger Privilege Summary

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:

Modify any other view property except those relating to triggers – Requires one of:

For privileges relating to triggers, see:

SAP Sybase IQ 16.0

View any view property page – None required.

Modify view permissions – Requires one of:

Modify a view comment – Requires any one of:

Modify any other view property, except those relating to triggers – Requires one of:

For privileges relating to view triggers, see: