Modify the root login policy

To modify the root 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 root and choose Properties.

  4. Modify a policy value and click OK.

To modify the root 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 root login policy for the locked and max_connections values.

ALTER LOGIN POLICY root 
locked=on
max_connections=5;
See also