Allow the granting of specific system privileges to specific users, with or without administrative rights.
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 |