DROP LOGIN POLICY policy-name 

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.

DBA authority.

None.

• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• CREATE LOGIN POLICY statement
• CREATE USER statement
• DROP USER statement
• Login policies
• Dropping a login policy

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

CREATE LOGIN POLICY Test11;
DROP LOGIN POLICY Test11;