Granting a System Privilege to a User

Allow the granting of specific system privileges to specific users, with or without administrative rights.

Prerequisites

Administrative privilege over the system privilege being granted.

Task

Warning! The syntax to grant a system privilege is the same for all system privileges except the CHANGE PASSWORD and SET USER system privileges.

Grant this system privilege using the WITH ADMIN OPTION, WITH NO ADMIN OPTION, or WITH ADMIN ONLY OPTION clause. If you do not specify a clause, the default is WITH NO ADMIN OPTION.

To grant a system privilege to a user, execute one of these statements:

Administrative Option	Statement
With full administrative rights	GRANT `system_privilege` TO `grantee [,...]` WITH ADMIN OPTION
With administrative rights only	GRANT `system_privilege` TO `grantee [,...]` WITH ADMIN ONLY OPTION
With no administrative rights	GRANT `system_privilege` TO `grantee [,...]` WITH NO ADMIN OPTION

Administrative Option

Statement

With full administrative rights

GRANT system_privilege TO grantee [,...]

WITH ADMIN OPTION

With administrative rights only

GRANT system_privilege TO grantee [,...]

WITH ADMIN ONLY OPTION

With no administrative rights

GRANT system_privilege TO grantee [,...]

WITH NO ADMIN OPTION