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.

Related tasks
Creating a Login Policy for a Simplex
Creating a Login Policy for a Multiplex
Deleting a Login Policy
Generating Login Policy DLL Command
Viewing or Modifying Login Policy Properties