External Login Privilege Summary

A list of the system privileges and object permissions required to complete the various external login tasks

Creating an External Login

Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • USER ADMIN authority.
SAP Sybase IQ 16.0 Requires MANAGE ANY USER system privilege.

Deleting an External Login

Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • USER ADMIN authority.
SAP Sybase IQ 16.0 Requires MANAGE ANY USER system privilege.

Generating External Login DDL Commands

Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.

Viewing External Login Properties

Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.
Related tasks
Creating an External Login
Deleting an External Login
Generating External Login DDL Commands
Viewing External Login Properties