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.
SAP Sybase IQ 16.0 None.

Starting or Stopping a Simplex Server

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

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.

Generating an Administration Script for a Simplex Server

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

Upgrading a Simplex Database

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

Viewing or Modifying Simplex Server Properties

Database Version Simplex Privileges
SAP Sybase IQ 15.3 and 15.4

View any simplex property page – none

Modify any simplex property – you must have DBA authority.

SAP Sybase IQ 16.0

View any simplex property page – none

Modify any property on the Configuration or Options property page – you must have 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
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group