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

Deleting a Login Policy

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

Generating Login Policy DDL Commands

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

Viewing Login Policy Properties

Database Version Login Policy Privileges
SAP Sybase IQ 15.3 and 15.4

View any login policy property page – none.

Modify any login policy property – You must have one of:
  • DBA authority
  • USER ADMIN authority
SAP Sybase IQ 16.0

View any login policy property page – none.

Modify any login policy property – you must have the 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