Simplex Privilege Summary

A list of the system privileges and object permissions required to complete the various simplex server tasks

Editing the Simplex Server Configuration File

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

Starting or Stopping a Simplex Server

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

Converting a Simplex Server to Multiplex

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.

Generating an Administration Script for a Simplex Server

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

Viewing or Modifying Simplex Server Properties

Database Version Simplex Privileges
SAP Sybase IQ 15.3 and 15.4

View any simplex property page – None required.

Modify any simplex property – Requires DBA authority.

SAP Sybase IQ 16.0

View any simplex property page – None required.

Modify any property on the Configuration or 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.
Related tasks
Editing the Simplex Server Configuration File
Starting a Simplex Server
Stopping a Simplex Server
Converting a Simplex Server to Multiplex
Generating an Administration Script for a Simplex Server
Viewing or Modifying Simplex Server Properties