Text Index Privilege Summary

A list of the system privileges and object permissions required to complete the various text index tasks.

Creating a Text Index

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

Also requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0 Requires 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.
Also requires:
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
  • If the system procedure security model* of the selected database is set to Invoker, you require one of the following system privileges 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
*The system procedure security model of the selected database appears on the General page of database properties.

Deleting a Text Index

Database Version Text Index Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • REFERENCE permission on the underlying table being indexed.
  • You own the underlying table being indexed.

Also requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0 Requires 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.
Also requires:
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
  • If the system procedure security model* of the selected database is set to Invoker, you require one of the following system privileges 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
*The system procedure security model of the selected database appears on the General page of database properties.

Refreshing a Text Index

Database Version Text Index Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • REFERENCE permission on the underlying table being indexed.
  • You own the underlying table being indexed.

Also requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0 Requires 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.
Also requires:
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
  • If the system procedure security model* of the selected database is set to Invoker, you require one of the following system privileges 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
*The system procedure security model of the selected database appears on the General page of database properties.

Truncating a Text Index

Database Version Text Index Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • ALTER permission on the table being indexed.
  • You own the underlying table being indexed.

Also requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0 Requires 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.
Also requires:
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
  • If the system procedure security model* of the selected database is set to Invoker, you require one of the following system privileges 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
*The system procedure security model of the selected database appears on the General page of database properties.

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, requires 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,
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
  • If the system procedure security model* of the selected database is set to Invoker, you require one of the following system privileges 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
*The system procedure security model of the selected database appears on the General page of database properties.

Viewing or Modifying Text Index Properties

Database Version Text Index Privileges
SAP Sybase IQ 15.3 and 15.4

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

View text index properties – None required.

Rename a text index – Requires one of:
  • DBA authority.
  • REFERENCE permission on the underlying table.
  • You own the underlying table being indexed.
Move a text index – Requires 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 – Requires one of:
  • DBA authority.
  • You own the underlying table being indexed.
SAP Sybase IQ 16.0
Requires:
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
  • If the system procedure security model* of the selected database is set to Invoker, you require one of the following system privileges 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
*The system procedure security model of the selected database appears on the General page of database properties.

View any text index property page – None required.

Rename a text index – Requires 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 – Requires 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 – Requires:
  • MANAGE ANY STATISTICS system privilege.
  • Also requires 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.
Parent topic: Configuring SAP Sybase IQ for Administration
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group