Allows users to checkpoint databases, drop connections (including those for users with SYS_AUTH_DBA_ROLE), back up databases, and monitor the system.
The WITH ADMIN ONLY OPTION and WITH ADMIN OPTION clauses are 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_OPERATOR_ROLE TO user_ID WITH ADMIN OPTION |
With administrative rights only |
GRANT ROLE SYS_AUTH_OPERATOR_ROLE TO user_ID WITH ADMIN ONLY OPTION |
With no administrative rights |
GRANT ROLE SYS_AUTH_OPERATOR_ROLE TO user_ID WITH NO ADMIN OPTION |
With no system privilege inheritance |
GRANT ROLE SYS_AUTH_OPERATOR_ROLE TO user_ID WITH NO SYSTEM PRIVILEGE INHERITANCE |
This example grants the SYS_AUTH_OPERATOR_ROLE to Mary with administrative rights and inheritance of the underlying system privileges of the role.
GRANT ROLE SYS_AUTH_OPERATOR_ROLE TO Mary WITH ADMIN OPTION
This example grants the SYS_AUTH_OPERATOR_ROLE to Joe with neither administrative rights or inheritance of the underlying system privileges of the role.
GRANT ROLE SYS_AUTH_OPERATOR_ROLE TO Joe WITH NO SYSTEM PRIVILEGE INHERITANCE