Text Configuration Privilege Summary

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

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 – Requires RESOURCE authority. Text configuration object to be owned by any user – Requires DBA authority.
SAP Sybase IQ 16.0	Text configuration object to be owned by self – Requires CREATE TEXT CONFIGURATION system privilege. Text configuration object to be owned by any user – Requires one of: CREATE ANY TEXT CONFIGURATION system privilege. CREATE ANY OBJECT system privilege. Also requires one of: ALTER ANY TEXT CONFIGURATION system privilege. ALTER ANY OBJECT system privilege.

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

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

Database Version	Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4	View any text object configuration property page – None required. Modify any text object configuration property – Requires one of: DBA authority. You own the text configuration object.
SAP Sybase IQ 16.0	View any text object configuration property page – None required. Modify a text configuration object term breaker or external prefilter property – Requires: CREATE ANY EXTERNAL REFERENCE system privilege. Also requires 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 – Requires 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 – Requires 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 required.

Modify any text object configuration property – Requires one of:

SAP Sybase IQ 16.0

View any text object configuration property page – None required.

Modify a text configuration object term breaker or external prefilter property – Requires:

CREATE ANY EXTERNAL REFERENCE system privilege.
Also requires 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 – Requires one of:

Modify any other text configuration object properties – Requires one of: