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. Use the SQL Anywhere 12 plug-in to 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
 See also