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)

Connect to the database as a user with DBA authority.
In the left pane, click Users & Groups.
In the right pane, right-click a user and then choose Properties.
In the Login Policy list, choose a login policy.
Click OK.

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

Connect to the database as a user with DBA authority.
Execute an ALTER USER statement.

Example

This example assigns the Test2 login policy to SQLTester.

ALTER USER SQLTester
LOGIN POLICY Test2;

Assigning a login policy to an existing user

Example

See also