Add role administrators to an existing role. There is no maximum number of role administrators that can be granted to a single role.
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 |
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