DROP SQL_BLOCK_RULE

Description

Deletes one or more SQL blocking rules. Multiple rules can be deleted at once by separating them with commas.

DROP SQL_BLOCK_RULE <rule_name>[, ...]

<rule_name> The name of the SQL blocking rule to be deleted. Multiple rule names can be specified, separated by commas.

Users executing this SQL command must have at least the following privileges:

Privilege	Object	Notes
ADMIN	User or Role	Only users or roles with the ADMIN privilege can perform the DROP operation.

Delete test_rule1 and test_rule2 blocking rules

DROP SQL_BLOCK_RULE test_rule1, test_rule2;