Alter a connection rule using SQL.

Syntax

ALTER {BEFORE | AFTER} CONNECTION RULE {AT POSITION n | WITH ID n} {SET [POSITION = n | DESCRIPTION 'string' | ALERT {NONE | NULL | string} | ENABLED {TRUE | FALSE}]};

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.
  • SET - make changes to the following clauses if they exist.

Clause Description Example
ALERT “name” Name of an existing alert action. This clause is optional ALERT “my alert action”
DESCRIPTION ‘description’ Optional text description of the CONNECTION RULE. This must be last in the statement or precede ENABLED. DESCRIPTION ‘Block user logins on weekends’
ENABLED Optional boolean value of TRUE or FALSE. ENABLED TRUE

Additional Information

Examples

Update the position and description

ALTER BEFORE CONNECTION RULE AT POSITION 20 SET DESCRIPTION 'an altered rule';

Change the alert and the description.

ALTER BEFORE CONNECTION RULE AT POSITION 20 SET ALERT "doctest email alert" DESCRIPTION 'second alteration';

Enable the alert and change position of execution.

ALTER BEFORE CONNECTION RULE AT POSITION 20 SET POSITION 25 ENABLED TRUE;

See Also