GRANT System Privilege Statement

Syntax

GRANT system_privilege_name [, …]  
  TO userID [, …] 
  [ {WITH NO ADMIN | WITH ADMIN [ ONLY ] } OPTION ]

system_privilege – must be the name of an existing system privilege.
userID – must be the name of an existing user or immutable role. The list must consist of existing users with login passwords. Separate multiple userIDs with commas.
WITH NO ADMIN OPTION – the user can manage the system privilege, but cannot grant the system privilege to another user.
WITH ADMIN ONLY OPTION – If the WITH ADMIN ONLY OPTION clause is used, each userID is granted administrative privileges over each system_privilege, but NOT the system_privilege itself.
WITH ADMIN OPTION – each userID is granted administrative privileges over each system_privilege in addition to all underlying system privileges of system_privilege.

Example 1 – grants the DROP CONNECTION system privilege to Joe with administrative privileges.
```
GRANT DROP CONNECTION TO Joe WITH ADMIN OPTION
```
Example 2 – grants the CHECKPOINT system privilege to Sally with no administrative privileges.
```
GRANT CHECKPOINT TO Sally WITH NO ADMIN OPTION
```
Example 3 – grants the MONITOR system privilege to Jane with administrative privileges only.
```
GRANT MONITOR TO Jane WITH ADMIN ONLY OPTION
```

By default, if no administrative clause is specified in the grant statement, the WITH NO ADMIN OPTION clause is used.

Requires administrative privilege over the system privilege being granted.