Making a User or Role a Global Role Administrator

Allow a user or role to act as a global role administrator.

Prerequisites

Requires the MANAGE ROLES system privilege granted with administrative rights.

Task

To become a global role administrator, you must be granted the MANAGE ROLES system privilege. Administrative rights on the MANAGE ROLES system privilege are not required to act as a global role administrator. If the MANAGE ROLES system privilege is granted to a role, all members of the role inherit the system privilege, and thus the ability to act as a global role administrator.

To grant the MANAGE ROLES system privilege execute this statement:

GRANT MANAGE ROLES TO grantee [,...]