Add the global role administrator to an existing role.
Prerequisites
Requires administrative privilege over the role.
Task
The global role administrator can be granted to a role with
administrative rights only (WITH ADMIN ONLY option).
To reinstate the global role administrator on a role, execute:
GRANT ROLE role_name TO SYS_MANAGE_ROLES_ROLE
WITH ADMIN ONLY OPTION