DROP LOGIN POLICY statement

Description

Removes a login policy from the database.

Syntax

DROP LOGIN POLICY policy-name

Examples

Example 1

This example creates the Test11 login policy and then deletes it.

CREATE LOGIN POLICY Test11; 
DROP LOGIN POLICY Test11 ;

Usage

A DROP LOGIN POLICY statement fails if you attempt to drop a policy that is assigned to a user. You can use either the ALTER USER statement to change the user's policy assignment or DROP USER to drop the user.

Permissions

Must have DBA or USER ADMIN authority.