Dropping a login policy

You cannot drop the root login policy. You must assign users to another login policy before dropping a customized login policy.

Note

You cannot drop a login policy if it is still assigned to a user.

 To drop a login policy (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 Login Policies.

  3. On the Login Policies pane, right-click a login policy and choose Delete.

  4. Click Yes.

 To drop a login policy (SQL)
  1. Connect to the database as a user with DBA authority.

  2. Execute a DROP LOGIN POLICY statement.

 Example
 See also