Use the GRANT statement (SQL form) to assign system level security constraint administrative privileges to a user or role. For example:
GRANT [CONSTRAINT DEFINITION|CONSTRAINT ASSIGNMENT] TO [admin_user_name (WITH GRANT OPTION)|admin_role_name] ;
where:
Privilege | Description |
---|---|
CONSTRAINT DEFINITION | Allows the user to CREATE, ALTER, or DROP CONSTRAINT objects, and execute the SHOW CONSTRAINT statement. |
CONSTRAINT ASSIGNMENT | Allows the user to:
|
[admin_user_name|admin_role_name] | The administrative user or role (grantee) receiving the privilege |
WITH GRANT OPTION | Allows the grantee to grant the row level security administrative privilege(s) to other users or roles. WITH GRANT OPTION is not applicable to role grants.
|