Users assigned more than one value for a security constraint can use SET SESSION CONSTRAINT to replace the default value with another assigned value, for example:
SET SESSION CONSTRAINT = constraint_name {(value_name ... [,value_name]|(NULL)} ... [,CONSTRAINT = constraint_name {(value_name ... [,value_name])|(NULL)}
where:
Syntax Element | Description |
---|---|
CONSTRAINT = constraint_name | A security constraint for which the user wants to reset the session default value, which must be:
A SET SESSION statement can specify maximum of 6 non-set and 2 set constraints. |
|
One or more value names that are valid for the specified constraint name and executing user. The value_name specification(s) replace the current session constraint value. If values for a constraint are already assigned to a session and the constraint is not named in the SET SESSION request, the values for that constraint remain unchanged. Value_name specifications are subject to the following limitations:
|