DROP SECURITY LEVEL

Use the DROP SECURITY LEVEL command to remove a security level.

Synopsis

Syntax for removing a security level:

DROP SECURITY LEVEL <level-name>

The DROP SECURITY LEVEL command has the following input:

Table 1. DROP SECURITY LEVEL input
Input	Description
<level_name>	The identifier of an existing level name.

The DROP SECURITY LEVEL command has the following outputs:

Table 2. DROP SECURITY LEVEL outputs
Output	Description
`DROP SECURITY LEVEL`	The message that the system returns if the command is successful.
`ERROR: permission denied.`	You must have Manage Security privilege to create a security level.
ERROR: object <level-name> not found.	The level name must exist.
ERROR: label security in use.	You cannot remove a security level after there is user data that might reference that level.

The DROP SECURITY LEVEL command removes a security level if there are no ROW SECURITY tables defined in any database in the system.

Privileges required: You must have Manage Security privilege to drop security levels.
Common tasks: Use the DROP SECURITY LEVEL command to remove a security level.

The following provides sample usage:

DROP SECURITY LEVEL SECRET;