Removes the specified network policy from the system.
Note
Only security administrators (i.e. users with the SECURITYADMIN role) can drop network policies.
CREATE NETWORK POLICY , ALTER NETWORK POLICY , SHOW NETWORK POLICIES , DESCRIBE NETWORK POLICY
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.
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.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
Drop a network policy named mypolicy:
DROP NETWORK POLICY mypolicy;Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4