Remove the global role administrator from a role.
Prerequisites
Administrative privilege over the role.
Task
A minimum number of role or global
role administrators (as defined by the MIN_ROLE_ADMINS database option) with a login password must exist for
each role at all times.
You can remove the global role administrator from a role as long as this minimum is still
met for the role.
To remove the global role administrator from a role, execute:
REVOKE ROLE role_name
FROM SYS_MANAGE_ROLES_ROLE