Modifies some or all option values for existing login policies in the database.
ALTER LOGIN POLICY policy-name {alter-clause}
{ policy-option-name=policy-option-value }
{ UNLIMITED | DEFAULT | value }
Option |
Description |
Values |
Initial value for ROOT policy |
Applies to |
---|---|---|---|---|
locked |
If the value for this option is ON, users are prohibited from establishing new connections |
ON, OFF |
OFF |
Users without DBA authority only |
max_connections |
The maximum number of concurrent connections allowed for a user. |
0 – 2147483647 |
Unlimited |
Users without DBA authority only |
max_days_since_login |
The maximum number of days that can elapse between two successive logins by the same user. |
0 – 2147483647 |
Unlimited |
Users without DBA authority only |
max_failed_login_attempts |
The maximum number of failed attempts, since the last successful attempt, to login to the user account before the account is locked. |
0 – 2147483647 |
Unlimited |
Users without DBA authority only |
max_non_dba_connections |
The maximum number of concurrent connections that a user without DBA authority can make. This option is only supported in the root login policy. |
0 – 2147483647 |
Unlimited |
Users without DBA authority only. Only to the root login policy. |
password_expiry_on_next_login |
If the value for this option is ON, the user's password will expire in the next login. |
ON, OFF |
OFF |
All users including those with DBA authority |
password_grace_time |
The number of days before password expiration during which login is allowed but the default post_login procedure issues warnings. |
0 – 2147483647 |
0 |
All users including those with DBA authority |
password_life_time |
The maximum number of days before a password must be changed. |
0 – 2147483647 |
Unlimited |
All users including those with DBA authority |
For syntax and usage related to multiplex servers only, see Using Sybase IQ Multiplex > Multiplex Reference > SQL Statements > ALTER LOGIN POLICY Statement.
Must have DBA or USER ADMIN authority.