To alter a login policy (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. In the left pane, click Login Policies.

3. In the right pane, right-click a login policy and choose Properties.

4. Alter the login policy value.

5. Click OK.

To alter a login policy (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute an ALTER LOGIN POLICY statement.

Example

This example creates overrides in the Test1 login policy for the locked and max_connections values.

ALTER LOGIN POLICY Test1 
locked=on
max_connections=5;

See also

• ALTER LOGIN POLICY statement
• Assigning a login policy to an existing user