Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Configuring your database » Managing user IDs, authorities, and permissions » Managing login policies

 

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