Alter Fence Statement

Modify an existing User Fence or Workload Fence.

Copy

ALTER ( (USERFENCE name [USERS user_name1[,..user_name2] | USERGROUPS group_name1[,..group_name2]] ) | (WORKLOADFENCE name) )  [NODES instance_name1[,..instance_name2]] [PROJECTS project_name1[,..project_name2]] [PRECEDENCE positive_integer];

where:

name is the name of the fence you want to modify.
user_name1..N is a comma separated list of user names to include in the fence.
group_name1..N is a comma separated list of user groups to include in the fence.
instance_name1..N is a comma separated list of nodes to include in the fence.
project_name1..N is a comma separated list of projects to include in the fence.
positive_integer is the order of precedence for the fence when multiple fences exist.

The highest PRECEDENCE value is 1. This will be the first fence in the fence list. An invalid or out-of-index value will add the specified fence to the end of the fence list. When PRECEDENCE is not specified in the command, the fence will be added to the end of the list.

When PROJECT is not specified in the command, the fence will apply to all the projects.

A User Fence must specify USERS or USERGROUP, while a Workload Fence does not.

Examples

Copy

ALTER USERFENCE "fence1" USERS "ADMINISTRATOR" NODES "node1", "node2" PROJECTS "MicroStrategy Tutorial" PRECEDENCE 1;

Copy

ALTER USERFENCE "fence2" USERGROUPS "Web USERS", "Customers" NODES "node3", "node4" PRECEDENCE 2;

Copy

ALTER WORKLOADFENCE "fence3" NODES "node5" PROJECTS "MicroStrategy Tutorial" PRECEDENCE 3;