Table Index Privilege Summary

Creating a Table Index

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	Requires CREATE permission on the specified dbspace. Also requires 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	Requires CREATE permission on the specified dbspace. Also requires 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	Requires 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	Requires 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	Requires 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	Requires 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	Requires 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	Require VALIDATE ANY OBJECT system privilege.

Moving a Table Index

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	Requires 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	Requires 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 required.
SAP Sybase IQ 16.0	None required.

Viewing or Modifying Index Properties

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	View table index fragmentation property page – Requires EXECUTE permission on the sp_iqindexfragmentation system procedure to display content of page. View any other table index property page – None required. Modify any index property – Requires 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 – If the system procedure security model^* of the selected database is set to Definer, you require EXECUTE permission on the sp_iqindexfragmentation system procedure to display content of page. If the system procedure security model^* of the selected database is set to Invoker, you require the MANAGE ANY DBSPACE system privilege to display content of page. ^*The system procedure security model of the selected database appears on the General page of database properties. View any other table index property page – None required. Modify a table 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. 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 – Requires 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 – Requires EXECUTE permission on the sp_iqindexfragmentation system procedure to display content of page.

View any other table index property page – None required.

Modify any index property – Requires 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 –

If the system procedure security model^* of the selected database is set to Definer, you require EXECUTE permission on the sp_iqindexfragmentation system procedure to display content of page.
If the system procedure security model^* of the selected database is set to Invoker, you require the MANAGE ANY DBSPACE system privilege to display content of page.

^*The system procedure security model of the selected database appears on the General page of database properties.

View any other table index property page – None required.

Modify a table 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.
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 –

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