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 You must have DBA authority.
SAP Sybase IQ 16.0 You must have the SERVER OPERATOR system privilege.

Testing a Remote Server Connection

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

Deleting a Remote Server

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

Generating Remote Server DDL Commands

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

Viewing or Modifying Remote Server Properties

Database Version Remote Server Privileges
SAP Sybase IQ 15.3 and 15.4

View remote server properties – none.

Modify remote server properties – you must have DBA authority.

SAP Sybase IQ 16.0

View any remote server property page – none.

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