Granting SYS_AUTH_SSO

Grant to allow users to perform authorized tasks pertaining to security and access control responsibilities.

Prerequisites

Administrative privilege over SYS_AUTH_SSO_ROLE role.

Task

You can grant this role with or without administrative rights. When granted with administrative rights, a user can manage (grant and revoke) the role, as well as use any of the underlying system privileges. When granted with administrative rights only, a user can manage the role, but not use its underlying system privileges. Finally, when granted with no administrative rights, a user can only use its underlying system privileges.

To grant the role, execute one of these statements:

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

Administrative Option

Statement

With full administrative rights

GRANT ROLE SYS_AUTH_SSO_ROLE TO grantee [,...]

WITH ADMIN OPTION

With administrative rights only

GRANT ROLE SYS_AUTH_SSO_ROLE TO grantee [,...]

WITH ADMIN ONLY OPTION

With no administrative rights

GRANT ROLE SYS_AUTH_SSO_ROLE TO grantee [,...]

WITH NO ADMIN OPTION

Granting SYS_AUTH_SSO_ROLE