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 You must have one of:
  • DBA authority
  • USER ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY USER system privilege.

Deleting an External Login

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

Generating External Login DDL Commands

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

Viewing External Login Properties

Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 None
SAP Sybase IQ 16.0 None
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