Remote Server Privilege Summary

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

Creating a Remote Server

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

Testing a Remote Server Connection

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

Deleting a Remote Server

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

Generating Remote Server DDL Commands

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

Viewing or Modifying Remote Server Properties

Database Version Remote Server Privileges
SAP Sybase IQ 15.3 and 15.4

View remote server properties – None required.

Modify remote server properties – Requires DBA authority.

SAP Sybase IQ 16.0

View any remote server property page – None required.

Modify any remote server property – Requires 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