Logical Server Privilege Summary

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

Creating a Logical Server

Database Version Logical Server 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.

Deleting a Logical Server

Database Version Logical Server 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.

Configuring Logical Server Node Membership

Database Version Logical Server 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.

Altering a Logical Server Assignment

Database Version Logical Server 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.

Generating DDL Commands for a Logical Server

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

Viewing or Modifying Logical Server Properties

Database Version Logical Server Privileges
SAP Sybase IQ 15.3 and 15.4

View logical server properties – none.

Modify logical server properties – you must have one of:
  • DBA authority
  • MULTIPLEX ADMIN authority
SAP Sybase IQ 16.0

View any logical server property page – none.

Modify any logical server property – you must have the MANAGE MULTIPLEX 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