Text Configuration Privilege Summary

Creating a Text Configuration Object

Database Version	Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4	Text configuration object to be owned by self – you must have RESOURCE authority. Text configuration object to be owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Text configuration object to be owned by self – you must have the CREATE TEXT CONFIGURATION system privilege. Text configuration object to be owned by any user – you must have one of: CREATE ANY TEXT CONFIGURATION system privilege CREATE ANY OBJECT system privilege You must also have one of: ALTER ANY TEXT CONFIGURATION system privilege ALTER ANY OBJECT system privilege

Deleting a Text Configuration Object

Database Version	Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4	Text configuration object owned by self – none. Table configuration object owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Text configuration object owned by self – none. Table configuration object owned by any user – you must have one of: DROP ANY TEXT CONFIGURATION system privilege DROP ANY OBJECT system privilege

Generating Text Configuration Object DDL Commands

Database Version	Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4	None.
SAP Sybase IQ 16.0	None.

Viewing or Modifying Text Configuration Object Properties

Database Version	Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4	View any text object configuration property page – none. Modify any text object configuration property – you must have one of: DBA authority You own the text configuration object
SAP Sybase IQ 16.0	View any text object configuration property page – none. Modify a text configuration object term breaker or external prefilter property – you must have the CREATE ANY EXTERNAL REFERENCE system privilege. You must also have one of: ALTER ANY TEXT CONFIGURATION system privilege ALTER ANY OBJECT system privilege You own the text configuration object Modify a text configuration object comment – you must have one of: CREATE ANY TEXT CONFIGURATION system privilege ALTER ANY TEXT CONFIGURATION system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege You own the text configuration Modify any other text configuration object properties – you must have one of: ALTER ANY TEXT CONFIGURATION system privilege ALTER ANY OBJECT system privilege You own the text configuration object

Database Version

Text Configuration Object Privileges

SAP Sybase IQ 15.3 and 15.4

View any text object configuration property page – none.

Modify any text object configuration property – you must have one of:

DBA authority
You own the text configuration object

SAP Sybase IQ 16.0

View any text object configuration property page – none.

Modify a text configuration object term breaker or external prefilter property – you must have the CREATE ANY EXTERNAL REFERENCE system privilege. You must also have one of:

ALTER ANY TEXT CONFIGURATION system privilege
ALTER ANY OBJECT system privilege
You own the text configuration object

Modify a text configuration object comment – you must have one of:

CREATE ANY TEXT CONFIGURATION system privilege
ALTER ANY TEXT CONFIGURATION system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
COMMENT ANY OBJECT system privilege
You own the text configuration

Modify any other text configuration object properties – you must have one of:

ALTER ANY TEXT CONFIGURATION system privilege
ALTER ANY OBJECT system privilege
You own the text configuration object