Login Policy Privilege Summary

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

Creating a Login Policy for a Simplex or Multiplex

Database Version Login Policy 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 LOGIN POLICY system privilege.

Deleting a Login Policy

Database Version Login Policy 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 LOGIN POLICY system privilege.

Generating Login Policy DDL Commands

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

Viewing Login Policy Properties

Database Version Login Policy Privileges
SAP Sybase IQ 15.3 and 15.4

View any login policy property page – None required.

Modify any login policy property – Requires one of:
  • DBA authority.
  • USER ADMIN authority.
SAP Sybase IQ 16.0

View any login policy property page – None required.

Modify any login policy property – Requires MANAGE ANY LOGIN POLICY system privilege.
Parent topic: Configuring SAP Sybase IQ for Administration
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