Assigning a login policy to an existing user

If you do not assign a customized login policy, users are assigned the root login policy. Use this procedure to change a user's login policy assignment.

To assign a login policy to an existing user (Sybase Central)

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

  2. In the left pane, click Users & Groups.

  3. In the right pane, right-click a user and then choose Properties.

  4. In the Login Policy list, choose a login policy.

  5. Click OK.

To assign a login policy to an existing user (SQL)

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

  2. Execute an ALTER USER statement.

Example

This example assigns the Test2 login policy to SQLTester.

ALTER USER SQLTester
LOGIN POLICY Test2;
See also