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 Requires one of:
  • DBA authority.
  • MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0 Requires MANAGE MULTIPLEX system privilege.

Deleting a Logical Server

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

Configuring Logical Server Node Membership

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

Altering a Logical Server Assignment

Database Version Logical Server 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 DDL Commands for a Logical Server

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

Viewing or Modifying Logical Server Properties

Database Version Logical Server Privileges
SAP Sybase IQ 15.3 and 15.4

View logical server properties – None required.

Modify logical server properties – Requires one of:
  • DBA authority.
  • MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0

View any logical server property page – None required.

Modify any logical server property – Requires MANAGE MULTIPLEX system privilege.

Related tasks
Creating a Logical Server
Deleting a Logical Server
Configuring Logical Server Node Membership
Altering a Logical Server Assignment
Generating DDL Commands for a Logical Server
Viewing or Modifying Logical Server Properties