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