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

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

• DROP LOGIN POLICY statement