Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions » Managing login policies overview

 

Altering a login policy

♦  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