A list of the system privileges and object permissions required to complete the various index tasks on tables.
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:
|
SAP Sybase IQ 16.0 | You must have CREATE permission on the specified dbspace. You must also have one of:
|
Database Version | Table Index Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Table Index Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Table Index Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have the VALIDATE ANY OBJECT system privilege. |
Database Version | Table Index Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Table Index Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 |
None |
SAP Sybase IQ 16.0 |
None |
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:
|
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:
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:
|