Multiplex Privilege Summary

Editing the Multiplex Configuration File

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

Starting or Stopping a Multiplex Server

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority.
SAP Sybase IQ 16.0	You must have the SERVER OPERATOR system privilege.

Including a Secondary Server

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You must have both of these authorities: MULTIPLEX ADMIN authority BACKUP authority
SAP Sybase IQ 16.0	You must have all of: MANAGE MULTIPLEX system privilege SERVER OPERATOR system privilege BACKUP DATABASE system privilege

Excluding a Secondary Server

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

Synchronizing a Secondary Server

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority.
SAP Sybase IQ 16.0	You must have all of: SERVER OPERATOR system privileges BACKUP DATABASE system privileges

Adding a Secondary Server

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

Dropping a Secondary Server

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

Generating an Administration Script for Multiplex Nodes

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

Converting a Simplex Server to Multiplex

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

Reconfiguring a Multiplex Server

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

Upgrading a Multiplex Server

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority.
SAP Sybase IQ 16.0	Not supported.

Viewing or Modifying Multiplex Server Properties

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	View multiplex properties – none. Modify multiplex properties – you must have one of: DBA authority MULTIPLEX ADMIN authority
SAP Sybase IQ 16.0	View multiplex properties – none. Modify any property on the Configuration page – you must have all of: SERVER OPERATOR system privilege BACKUP DATABASE system privilege MANAGE MULTIPLEX system privilege Modify any property on the Options property page – you must have the SERVER OPERATOR system privilege. Modify any property on the Request Logging property page – you must have one of: MANAGE PROFILING system privilege SERVER OPERATOR system privilege Modify any property on the High Availability property page – you must have the MANAGE MULTIPLEX system privilege, and the coordinator must be running. The SCC agent for the multiplex server for which the Properties page is open must also be running.

Database Version

Multiplex Privileges

SAP Sybase IQ 15.3 and 15.4

View multiplex properties – none.

Modify multiplex properties – you must have one of:

DBA authority
MULTIPLEX ADMIN authority

SAP Sybase IQ 16.0

View multiplex properties – none.

Modify any property on the Configuration page – you must have all of:

SERVER OPERATOR system privilege
BACKUP DATABASE system privilege
MANAGE MULTIPLEX system privilege

Modify any property on the Options property page – you must have the SERVER OPERATOR system privilege.

Modify any property on the Request Logging property page – you must have one of:

MANAGE PROFILING system privilege
SERVER OPERATOR system privilege

Modify any property on the High Availability property page – you must have the MANAGE MULTIPLEX system privilege, and the coordinator must be running. The SCC agent for the multiplex server for which the Properties page is open must also be running.

Designating the Failover Node

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

Performing Coordinator Node Failover

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