Allows users to perform all authorized tasks.
The WITH ADMIN ONLY OPTION clause is invalid when using the WITH NO SYSTEM PRIVILEGE INHERITANCE clause. The WITH NO ADMIN OPTION clause is valid, but not required, as it is semantically equivalent to the WITH NO SYSTEM PRIVILEGE INHERITANCE clause.
Administrative Option | Statement |
---|---|
With full administrative rights |
GRANT ROLE SYS_AUTH_DBA_ROLE TO grantee [,...] WITH ADMIN OPTION |
With administrative rights only |
GRANT ROLE SYS_AUTH_DBA_ROLE TO grantee [,...] WITH ADMIN ONLY OPTION |
With no administrative rights |
GRANT ROLE SYS_AUTH_DBA_ROLE TO grantee [,...] WITH NO ADMIN OPTION |
With full administrative rights, but no system privilege inheritance |
GRANT ROLE SYS_AUTH_REMOTE_DBA_ROLE TO user_ID WITH ADMIN OPTION WITH NO SYSTEM PRIVILEGE INHERITANCE |