Materialized View Index Privilege Summary

A list of the system privileges and object permissions required to complete the various index tasks materialized views.

Creating a Materialized View Index

Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • You own the underlying database object of the index
SAP Sybase IQ 16.0 You must have one of:
  • CREATE ANY OBJECT system privilege
  • CREATE permission on the dbspace, along with one of:
    • CREATE ANY INDEX system privilege
    • You own the materialized view index

Deleting a Materialized View Index

Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • RESOURCE authority with ALTER permission on the underlying database object of the index
  • You own the underlying database object of the index
SAP Sybase IQ 16.0 You must have one of:
  • DROP ANY INDEX system privilege
  • DROP ANY OBJECT system privilege
  • You own the materialized index

Rebuilding a Materialized View Index

Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • RESOURCE authority with ALTER permission on the underlying database object of the index
  • You own the underlying database object of the index
SAP Sybase IQ 16.0 You must have one of:
  • ALTER ANY INDEX system privilege
  • ALTER ANY OBJECT system privilege
  • You own the underlying database object of the index

Validating a Materialized View Index

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

Generating Materialized View Index DDL Commands

Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4

None.
SAP Sybase IQ 16.0

None.

Viewing or Modifying Materialized View Index Properties

Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4

View any materialized view index property page – none.

Modify any materialized view index property – you must have one of:
  • DBA authority
  • RESOURCE authority with ALTER permission on the underlying database object of the index
  • You own the underlying database object of the index
SAP Sybase IQ 16.0

View any materialized view index property page – none.

Modify a materialized view index comment – you must have one of:
  • CREATE ANY INDEX system privilege
  • ALTER ANY INDEX system privilege
  • CREATE ANY OBJECT system privilege
  • ALTER ANY OBJECT system privilege
  • COMMENT ANY OBJECT system privilege
Note: ALTER permission on the materialized view is not required to modify the comment only.

Modify any other materialized view index property – you must have one of:

  • ALTER ANY OBJECT system privilege
  • CREATE permission on the dbspace, along with one of:
    • ALTER ANY INDEX system privilege
    • You own the materialized view
Parent topic: Materialized View Indexes