You can change security constraint assignments for a user in a MODIFY USER statement. When you specify a security constraint that is:
- Not currently assigned to the user, the constraint is added to any existing constraints
- Already assigned to the user, the new specifications replace the existing specifications
- Already assigned to the user, followed by the keyword NULL, the constraint assignment is dropped from the user