ALTER LOGIN POLICY Statement

Syntax

Syntax 1

ALTER LOGIN POLICY policy-name 
{ { ADD | DROP | SET } LOGICAL SERVER ls-assignment-list 
[ LOGICAL SERVER ls-override-list ])

ls-assignment-list –

{ { ls-name, ...}  | ALL | COORDINATOR | SERVER | NONE | DEFAULT }

ls-override-list –
```
{ ls-name, ...}
```
ls-name –
```
{ OPEN | user-defined-ls-name }
```
policy-option-value –
```
{ UNLIMITED | DEFAULT | value }
```

Syntax 2

ALTER LOGIN POLICY policy-name
AUTO_UNLOCK_TIME=0 – UNLIMITED
| CHANGE_PASSWORD_DUAL_CONTROL=[ON | OFF]
| DEFAULT_LOGICAL_SERVER=[logical_server_name | ALL | AUTO | COORDINATOR | NONE | OPEN | SERVER]
| LOCKED=[ON | OFF]
| MAX_CONNECTIONS=0 – 2147483647
| MAX_DAYS_SINCE_LOGIN=0 – 2147483647
| MAX_FAILED_LOGIN_ATTEMPTS=0 – 2147483647
| MAX_NON_DBA_CONNECTIONS=0 – 2147483647
| PASSWORD_EXPIRY_ON_NEXT_LOGIN=[ON | OFF]
| PASSWORD_GRACE_TIME=0 – 2147483647
| PASSWORD_LIFE_TIME=0 – 2147483647
| ROOT_AUTO_UNLOCK_TIME=0 – UNLIMITED
| LDAP_PRIMARY_SERVER=server_name
| LDAP_SECONDARY_SERVER=server_name
| LDAP_AUTO_FAILBACK_PERIOD=0 – 2147483647
| LDAP_FAILOVER_TO_STD=[ON | OFF]
| LDAP_REFRESH_DN=NOW

Applies to

Simplex and multiplex.

Examples

Example 1 – see Logical Server Access Configuration and Multiplex Login Policy Configuration .
Example 2 – sets the password_life_time value to UNLIMITED and the max_failed_login_attempts value to 5 in the Test1 login policy.
```
ALTER LOGIN POLICY Test1 
password_life_time=UNLIMITED
max_failed_login_attempts=5; 
```

Permissions

Requires the MANAGE ANY LOGIN POLICY system privilege.