Delete connection rules.

Syntax

DROP {BEFORE | AFTER} CONNECTION RULE AT POSITION n

Arguments

  • {BEFORE | AFTER}

    • BEFORE - connection rule that executes when login attempt made. Cannot use MEMBER OF clause.

    • AFTER - connection rule that executes after successful login.

  • AT POSITION n - Numeric value representing the order the rule will be executed.

Determine the rule position by querying the database.

select * from SYS.RULES where enabled=true and deleted_at is null order by rule_type, position;

Example

DROP BEFORE CONNECTION RULE AT POSITION 10;

See Also