Remove the global role administrator from a role.
Prerequisites
Requires 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