Granting SYS_AUTH_SPACE_ADMIN

Allows users to manage dbspaces.

Prerequisites

Administrative privilege over SYS_AUTH_SPACE_ADMIN_ROLE.

Task

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

To grant the SYS_AUTH_SPACE_ADMIN_ROLE role, execute one of the following statements:

Administrative Option	Statement
With full administrative rights	GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO `user_ID` WITH ADMIN OPTION
With administrative rights only	GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO `user_ID` WITH ADMIN ONLY OPTION
With no administrative rights	GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO `user_ID` WITH NO ADMIN OPTION

Administrative Option

Statement

With full administrative rights

GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO user_ID

WITH ADMIN OPTION

With administrative rights only

GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO user_ID

WITH ADMIN ONLY OPTION

With no administrative rights

GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO user_ID

WITH NO ADMIN OPTION

Example:

This example grants the SYS_AUTH_SPACE_ADMIN_ROLE to Mary, with no administrative rights.

GRANT ROLE SYS_AUTH_SPACE_ADMIN_ROLE TO Mary WITH NO ADMIN OPTION

Granting SYS_AUTH_SPACE_ADMIN_ROLE