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. 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

This example drops the Test1 login policy.

DROP LOGIN POLICY Test1;
See also