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

ALTER ACCOUNT

Syntax¶

DROP NETWORK POLICY [ IF EXISTS ] <name>
Copy

Parameters¶

name

Specifies 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;
Copy