Adding Role Administrators to an Existing Role

Add role administrators to an existing role. There is no maximum number of role administrators that can be granted to a single role.

Prerequisites

Requires administrative privilege over the role, or the MANAGE ROLES system privilege, if the role has a global role administrator.

Task

To add role administrators, execute one of these statements:

Grant Type	Statement
Administrative privileges only	GRANT ROLE `role_name` TO `admin_name [,...]` WITH ADMIN ONLY OPTION
Administrative privileges and role membership	GRANT ROLE `role_name` TO `admin_name [,...]` WITH ADMIN OPTION

Grant Type

Statement

Administrative privileges only

GRANT ROLE role_name TO admin_name [,...]

WITH ADMIN ONLY OPTION

Administrative privileges

and role membership

GRANT ROLE role_name TO admin_name [,...]

WITH ADMIN OPTION

Example:

Execute this statement to make Mary and Bob role administrators of the Sales role.

GRANT ROLE Sales TO Mary, Bob WITH ADMIN ONLY OPTION

Each can administer the role, but not use its underlying system privileges because of the WITH ADMIN ONLY OPTION clause.

Execute this statement to make Sarah a role administrator of the Sales role with the ability to both administer the role and use its underlying system privileges because of the WITH ADMIN OPTION clause.

GRANT ROLE Sales TO Sarah WITH ADMIN OPTION