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 Requires one of:
  • DBA authority
  • You own the underlying database object of the index.
SAP Sybase IQ 16.0 Requires 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 Requires 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 Requires 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 Requires 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 Requires 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 Requires one of:
  • DBA authority.
  • VALIDATE authority.
SAP Sybase IQ 16.0 Requires 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 required.
SAP Sybase IQ 16.0

None required.

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 required.

Modify any materialized view index property – Requires 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 required.

Modify a materialized view index comment – Requires 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 – Requires 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