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

• ALTER USER statement
• Creating new users