Multiplex Privilege Summary

Editing the Multiplex Configuration File

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	None required.
SAP Sybase IQ 16.0	None required.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires DBA authority.
SAP Sybase IQ 16.0	Requires SERVER OPERATOR system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. All of these authorities: MULTIPLEX ADMIN authority, and BACKUP authority.
SAP Sybase IQ 16.0	Requires all of: MANAGE MULTIPLEX system privilege. SERVER OPERATOR system privilege. BACKUP DATABASE system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE MULTIPLEX system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires DBA authority.
SAP Sybase IQ 16.0	Requires both SERVER OPERATOR and BACKUP DATABASE system privileges.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. All of these authorities: MULTIPLEX ADMIN authority. SPACE ADMIN authority. BACKUP authority.
SAP Sybase IQ 16.0	Requires all of: SERVER OPERATOR system privilege. MANAGE MULTIPLEX system privilege. MANAGE ANY DBSPACE system privilege. BACKUP DATABASE system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. All of these authorities: MULTIPLEX ADMIN authority. SPACE ADMIN authority. BACKUP authority.
SAP Sybase IQ 16.0	Requires all of: MANAGE MULTIPLEX system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	None required.
SAP Sybase IQ 16.0	None required.

Database Version	Simplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE MULTIPLEX system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Change server name, port or database location – Requires all of: MULTIPLEX ADMIN authority. BACKUP authority. All other changes require DBA authority.
SAP Sybase IQ 16.0	Requires all of: SERVER OPERATOR system privilege. BACKUP DATABASE system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	View multiplex properties – None required. Modify multiplex properties – Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	View multiplex properties – None required. Modify any property on the Configuration – Requires all of: SERVER OPERATOR system privilege. BACKUP DATABASE system privilege. MANAGE MULTIPLEX system privilege. Modify any property on the Options property page – Requires SERVER OPERATOR system privilege. Modify any property on the Request Logging property page – Requires one of: MANAGE PROFILING system privileges. SERVER OPERATOR system privileges.

Database Version

Multiplex Privileges

SAP Sybase IQ 15.3 and 15.4

View multiplex properties – None required.

Modify multiplex properties – Requires one of:

SAP Sybase IQ 16.0

View multiplex properties – None required.

Modify any property on the Configuration – Requires all of:

Modify any property on the Options property page – Requires SERVER OPERATOR system privilege.

Modify any property on the Request Logging property page – Requires one of:

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires DBA authority.
SAP Sybase IQ 16.0	Requires all of: MANAGE MULTIPLEX system privilege. SERVER OPERATOR system privilege. BACKUP DATABASE system privilege.

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE MULTIPLEX system privilege.