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)}
- CONSTRAINT = constraint_name
- A security constraint for which the user wants to reset the session default value, which must be:
- An existing CONSTRAINT object
- Currently assigned to the user
- value_name
- One or more value names that are valid for the specified constraint name and executing user.
- [,value_name ]|(NULL)
- If the constraint name is followed by the NULL option, the constraint is removed from the session label.