ORA-26988: Cannot grant Oracle GoldenGate privileges. The procedure GRANT_ADMIN_PRIVILEGE is disabled.

Problem:

While trying to grant the privilege to Golden Gate user in 23ai database, I received the following error:

SQL> EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('GGADMIN');
BEGIN DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('GGADMIN'); END;

*
ERROR at line 1:
ORA-26988: Cannot grant Oracle GoldenGate privileges. The procedure GRANT_ADMIN_PRIVILEGE is disabled.
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 601
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 636
ORA-06512: at "SYS.DBMS_GOLDENGATE_AUTH", line 38
ORA-06512: at line 1
Help: https://docs.oracle.com/error-help/db/ora-26988/

Explanation:

With Oracle Database release 23ai, procedures are replaced by roles.

Solution:

Grant the following Oracle GoldenGate roles: OGG_CAPTURE for Extract, OGG_APPLY for Replicat, and OGG_APPLY_PROCREP for procedural replication with Replicat.

grant OGG_APPLY to GGADMIN;
grant OGG_APPLY_PROCREP to GGADMIN;
grant OGG_CAPTURE to GGADMIN;