Table Index Privilege Summary

Creating a Table Index

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have CREATE permission on the specified dbspace. You must also have one of: DBA authority REFERENCE permission on the underlying table of the index You own the underlying table of the index
SAP Sybase IQ 16.0	You must have CREATE permission on the specified dbspace. You must also have one of: CREATE ANY INDEX system privilege CREATE ANY OBJECT system privilege REFERENCE permission on the underlying table of the index You own the underlying table of the index

Deleting a Table Index

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority RESOURCE authority with REFERENCE permission on the underlying table of the index You own the underlying table of the index
SAP Sybase IQ 16.0	You must have one of: DROP ANY INDEX system privilege DROP ANY OBJECT system privilege REFERENCE permission on the underlying table of the index You own the underlying table of the index

Rebuilding a Table Index

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

Validating a Table Index

Database Version	Table 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 table of the index You own the underlying table of the index
SAP Sybase IQ 16.0	You must have the VALIDATE ANY OBJECT system privilege.

Moving a Table Index

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SPACE ADMIN authority CREATE permission on the target dbspace, along with one of: You own the underlying table You have REFERENCE permission on the underlying table
SAP Sybase IQ 16.0	You must have one of: ALTER ANY INDEX system privilege ALTER ANY OBJECT system privilege MANAGE ANY DBSPACE system privilege You own the underlying table of the index REFERENCE permission on the table along with one of: CREATE ANY OBJECT system privilege CREATE permission on the target dbspace

Generating Index DDL Commands

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	None
SAP Sybase IQ 16.0	None

Viewing or Modifying Index Properties

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	View table index fragmentation property page – you must have EXECUTE permission on the sp_iqindexfragmentation system procedure to display the content of the page. View any other table index property page – none. Modify any index property – you must have one of: DBA authority RESOURCE authority with REFERENCE permission on the underlying table of the index You own the underlying table of the index
SAP Sybase IQ 16.0	View table index fragmentation property page – you must have EXECUTE permission on the sp_iqindexfragmentation system procedure along with the MANAGE ANY DBSPACE system privilege to display the content of the page. View any other table index property page – none. Modify a table 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 You own the underlying table of the index Note: ALTER permission on the table is not required to modify the comment only. Modify any other table index property – you must have one of: ALTER ANY OBJECT system privilege ALTER ANY INDEX system privilege REFERENCE permission on the underlying table of the index You own the underlying table of the index

Database Version

Table Index Privileges

SAP Sybase IQ 15.3 and 15.4

View table index fragmentation property page – you must have EXECUTE permission on the sp_iqindexfragmentation system procedure to display the content of the page.

View any other table index property page – none.

Modify any index property – you must have one of:

DBA authority
RESOURCE authority with REFERENCE permission on the underlying table of the index
You own the underlying table of the index

SAP Sybase IQ 16.0

View table index fragmentation property page – you must have EXECUTE permission on the sp_iqindexfragmentation system procedure along with the MANAGE ANY DBSPACE system privilege to display the content of the page.

View any other table index property page – none.

Modify a table 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
You own the underlying table of the index

Note: ALTER permission on the table is not required to modify the comment only.

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

ALTER ANY OBJECT system privilege
ALTER ANY INDEX system privilege
REFERENCE permission on the underlying table of the index
You own the underlying table of the index