Text Index Privilege Summary

Creating a Text Index

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority REFERENCE permission on the underlying table being indexed along with CREATE permission on the dbspace where the index is being created You own the underlying table being indexed along with CREATE permission on the dbspace where the index is being created You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	You must have one of: CREATE ANY INDEX system privilege along with CREATE permission on the dbspace where the index is being created CREATE ANY OBJECT system privilege You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
REFERENCE permission on the underlying table being indexed along with CREATE permission on the dbspace where the index is being created
You own the underlying table being indexed along with CREATE permission on the dbspace where the index is being created

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

You must have one of:

CREATE ANY INDEX system privilege along with CREATE permission on the dbspace where the index is being created
CREATE ANY OBJECT system privilege

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

MANAGE ANY STATISTICS system privilege
CREATE ANY INDEX system privilege
ALTER ANY INDEX system privilege
DROP ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
DROP ANY OBJECT system privilege

Deleting a Text Index

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority REFERENCE permission on the underlying table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
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 being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
REFERENCE permission on the underlying table being indexed
You own the underlying table being indexed

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

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 being indexed
You own the underlying table being indexed

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

MANAGE ANY STATISTICS system privilege
CREATE ANY INDEX system privilege
ALTER ANY INDEX system privilege
DROP ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
DROP ANY OBJECT system privilege

Refreshing a Text Index

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority REFERENCE permission on the underlying table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
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 being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
REFERENCE permission on the underlying table being indexed
You own the underlying table being indexed

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

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 being indexed
You own the underlying table being indexed

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

MANAGE ANY STATISTICS system privilege
CREATE ANY INDEX system privilege
ALTER ANY INDEX system privilege
DROP ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
DROP ANY OBJECT system privilege

Truncating a Text Index

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority ALTER permission on the table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	You must have one of: ALTER ANY INDEX system privilege ALTER ANY OBJECT system privilege ALTER permission on the table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
ALTER permission on the table being indexed
You own the underlying table being indexed

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

You must have one of:

ALTER ANY INDEX system privilege
ALTER ANY OBJECT system privilege
ALTER permission on the table being indexed
You own the underlying table being indexed

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

MANAGE ANY STATISTICS system privilege
CREATE ANY INDEX system privilege
ALTER ANY INDEX system privilege
DROP ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
DROP ANY OBJECT system privilege

Generating Text Index DDL Commands

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	None required to generate DDL commands; however, you must have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	None required to generate DDL commands; however, you must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

None required to generate DDL commands; however, you must have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

None required to generate DDL commands; however, you must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

MANAGE ANY STATISTICS system privilege
CREATE ANY INDEX system privilege
ALTER ANY INDEX system privilege
DROP ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
DROP ANY OBJECT system privilege

Viewing or Modifying Text Index Properties

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes. View text index properties – none. Rename a text index – you must have one of: DBA authority REFERENCE permission on the underlying table You own the underlying table being indexed Move a text index – you must have one of: DBA authority SPACE ADMIN authority You own the underlying table being indexed and have CREATE permission on the target dbspace Modify comment on a text index – you must have one of: DBA authority You own the underlying table being indexed
SAP Sybase IQ 16.0	You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege View any text index property page – none. Rename a text index – you must have one of: ALTER ANY INDEX system privilege ALTER ANY OBJECT system privilege REFERENCE permission on the underlying table You own the underlying table being indexed Move a text index – you must have one of: ALTER ANY INDEX system privilege ALTER ANY OBJECT system privilege MANAGE ANY DBSPACE One of the following: You own the underlying table being indexed REFERENCE permission on the table along with one of the following: CREATE ANY OBJECT system privilege CREATE permission on the target dbspace Modify a text index comment – you must have the MANAGE ANY STATISTICS system privilege. You must also have one of: ALTER ANY INDEX system privilege ALTER ANY OBJECT system privilege CREATE ANY OBJECT system privilege CREATE ANY INDEX system privilege COMMENT ANY OBJECT system privilege You own the underlying table being indexed

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

View text index properties – none.

Rename a text index – you must have one of:

DBA authority
REFERENCE permission on the underlying table
You own the underlying table being indexed

Move a text index – you must have one of:

DBA authority
SPACE ADMIN authority
You own the underlying table being indexed and have CREATE permission on the target dbspace

Modify comment on a text index – you must have one of:

DBA authority
You own the underlying table being indexed

SAP Sybase IQ 16.0

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

MANAGE ANY STATISTICS system privilege
CREATE ANY INDEX system privilege
ALTER ANY INDEX system privilege
DROP ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
DROP ANY OBJECT system privilege

View any text index property page – none.

Rename a text index – you must have one of:

ALTER ANY INDEX system privilege
ALTER ANY OBJECT system privilege
REFERENCE permission on the underlying table
You own the underlying table being indexed

Move a text index – you must have one of:

ALTER ANY INDEX system privilege
ALTER ANY OBJECT system privilege
MANAGE ANY DBSPACE
One of the following:
- You own the underlying table being indexed
- REFERENCE permission on the table along with one of the following:
  - CREATE ANY OBJECT system privilege
  - CREATE permission on the target dbspace

Modify a text index comment – you must have the MANAGE ANY STATISTICS system privilege. You must also have one of:

ALTER ANY INDEX system privilege
ALTER ANY OBJECT system privilege
CREATE ANY OBJECT system privilege
CREATE ANY INDEX system privilege
COMMENT ANY OBJECT system privilege
You own the underlying table being indexed