ALTER LOGIN POLICY Statement

This statement performs two functions. It can modify option values for existing login policies in the database or configure logical server access.

Syntax

ALTER LOGIN POLICY policy-name {alter-clause}
 

Parameters

  • alter-clause:
    { { ADD | DROP | SET } LOGICAL SERVER ls-assignment-list 
    		| policy-option-name = policy-option-value [ LOGICAL SERVER ls-override-list ] 
    }
  • ls-assignment-list:
    { { ls-name, ...} | SERVER | NONE | DEFAULT }
  • ls-override-list:
    { ls-name, ...}
  • ls-name:
    { OPEN | user-defined-ls-name }
  • policy-option-value:
    { UNLIMITED | DEFAULT | value }

Examples

  • Example 1 – See Logical Server Access Configuration and Login Policy Option Configuration.

Usage

See Logical Server Access Configuration and Login Policy Option Configuration.

Permissions

Must have DBA or USER ADMIN authority.