DROP NETWORK POLICY¶
Removes the specified network policy from the system.
Note
Only security administrators (i.e. users with the SECURITYADMIN role) can drop network policies.
- See also:
CREATE NETWORK POLICY , ALTER NETWORK POLICY , SHOW NETWORK POLICIES , DESCRIBE NETWORK POLICY
Syntax¶
DROP NETWORK POLICY [ IF EXISTS ] <name>
Parameters¶
nameSpecifies the identifier for the network policy to drop. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
Usage notes¶
Only the network policy owner (i.e. role with the OWNERSHIP privilege on the network policy) or higher can execute this command.
Dropped network policies cannot be recovered; they must be recreated.
A network policy cannot be dropped if it is currently assigned to an account, security integration, or user.
Examples¶
Drop a network policy named mypolicy:
DROP NETWORK POLICY mypolicy;