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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (A-D)

 

DROP LOGIN POLICY statement

Use this statement to drop a login policy.

Syntax
DROP LOGIN POLICY policy-name 
Parameters
  • policy-name   The name of the login policy.

Remarks

The statement fails if you drop a policy that is assigned to a user. You cannot drop the root login policy. Use the ALTER USER statement to change a user's policy assignment. See ALTER USER statement.

Permissions

Must have DBA authority.

Side effects

None.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Examples

The following example creates a login policy, Test11, and then deletes it.

CREATE LOGIN POLICY Test11;
DROP LOGIN POLICY Test11;