Materialized View Privilege Summary

Creating a Materialized View

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	Materialized view to be owned by self – you must have RESOURCE authority with SELECT permission on tables in the view definition. You must also have CREATE permission on the selected dbspace to create a view owned by you. Materialized view to be owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Materialized view to be owned by self – you must have CREATE MATERIALIZED VIEW system privilege. You must also have one of: CREATE ANY OBJECT system privilege CREATE object permission on the dbspace where the materialized view is being created Finally, you must have one of: SELECT ANY TABLE system privilege SELECT object permission on the underlying tables of the materialized view Materialized view to be owned by any user – you must have CREATE object permission on the dbspace where the materialized view is being created. You must also have one of: CREATE ANY MATERIALIZED VIEW system privilege CREATE ANY OBJECT system privilege Finally, you must have one of: SELECT ANY TABLE system privilege SELECT object permission on the underlying tables of the materialized view

Database Version

Materialized View Privileges

SAP Sybase IQ 15.3 and 15.4

Materialized view to be owned by self – you must have RESOURCE authority with SELECT permission on tables in the view definition. You must also have CREATE permission on the selected dbspace to create a view owned by you.

Materialized view to be owned by any user – you must have DBA authority.

SAP Sybase IQ 16.0

Materialized view to be owned by self – you must have CREATE MATERIALIZED VIEW system privilege. You must also have one of:

CREATE ANY OBJECT system privilege
CREATE object permission on the dbspace where the materialized view is being created

Finally, you must have one of:

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

Materialized view to be owned by any user – you must have CREATE object permission on the dbspace where the materialized view is being created. You must also have one of:

CREATE ANY MATERIALIZED VIEW system privilege
CREATE ANY OBJECT system privilege

Finally, you must have one of:

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

Viewing Materialized View Data in the Execute SQL Window

Database Version	Materialized 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.

Truncating Materialized View Data

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the materialized view
SAP Sybase IQ 16.0	You must have one of: TRUNCATE ANY TABLE system privilege ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege TRUNCATE permission on the materialized view You own the materialized view

Validating Materialized View Data

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the materialized view
SAP Sybase IQ 16.0	You must have the VALIDATE ANY OBJECT system privilege.

Refreshing Materialized View Data

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority. You must also have both of: INSERT permission on the underlying tables of the materialized view or you own the materialized view SELECT permission on the underlying tables of the materialized view or you own the underlying tables of the materialized view
SAP Sybase IQ 16.0	You must have one of: INSERT ANY TABLE system privilege INSERT permission on the materialized view You own the materialized view You must also have one of: SELECT ANY TABLE system privilege SELECT permission on the underlying tables of the materialized view You own the underlying tables of the materialized view

Recompiling and Enabling Materialized View Data

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

Disabling Materialized View Data

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the materialized view
SAP Sybase IQ 16.0	You must have one of: ALTER ANY MATERIALIZED VIEW system privilege ALTER ANY OBJECT system privilege You own the materialized view

Deleting a Materialized View

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority.
SAP Sybase IQ 16.0	You must have one of: DROP ANY MATERIALIZED VIEW system privilege DROP ANY OBJECT system privilege You own the materialized view

Generating Materialized View DDL Commands

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

Setting a Clustered Index on a Materialized View

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the materialized view
SAP Sybase IQ 16.0	You must have one of: ALTER ANY MATERIALIZED VIEW system privilege ALTER ANY OBJECT system privilege You own the materialized view

Viewing or Modifying Materialized View Properties

Database Version	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	View any materialized view property page – none. Modify materialized view permissions – You must have one of: DBA authority PERMS ADMIN authority Administrative rights over the permission You own the database object Modify the SQL page of the materialized view properties – you must have one of: DBA authority You own the materialized view and have SELECT permission on the underlying tables Modify any other materialized view property except those relating to indexes – you must have one of: DBA authority ALTER permission on the underlying tables SELECT permission on the underlying tables You own the materialized view For privileges relating to materialized view indexes, see: Materialized View Index Privilege Summary
SAP Sybase IQ 16.0	View any materialized view property page – none. Modify materialized 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 materialized view comment – you must have one of: CREATE ANY MATERIALIZED VIEW system privilege ALTER ANY MATERIALIZED VIEW system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege You own the materialized view Modify the SQL page of the materialized view properties – you must have one of: DROP ANY MATERIALIZED VIEW system privilege DROP ANY OBJECT system privilege You own the materialized view You must also have one of: CREATE ANY MATERIALIZED VIEW system privilege CREATE ANY OBJECT system privilege Modify any other materialized view property except those relating to indexes – you must have one of: ALTER ANY MATERIALIZED VIEW system privilege ALTER ANY OBJECT system privilege You own the materialized view For privileges relating to materialized view indexes, see: Materialized View Index Privilege Summary

Database Version

Materialized View Privileges

SAP Sybase IQ 15.3 and 15.4

View any materialized view property page – none.

Modify materialized view permissions – You must have one of:

DBA authority
PERMS ADMIN authority
Administrative rights over the permission
You own the database object

Modify the SQL page of the materialized view properties – you must have one of:

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

Modify any other materialized view property except those relating to indexes – you must have one of:

DBA authority
ALTER permission on the underlying tables
SELECT permission on the underlying tables
You own the materialized view

For privileges relating to materialized view indexes, see:

Materialized View Index Privilege Summary