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
Creating a Remote Server
Testing a Remote Server Connection
Deleting a Remote Server
Generating Remote Server DDL Commands
Viewing or Modifying Remote Server Properties