WARNING OGG-00706 Failed to add supplemental log group on table HR.TEST due to ORA-01031: insufficient privileges

Problem:

I received a warning while running the following command in GGSCI:

GGSCI (rac1.mycompany.mydomain as ggcw@orcl2) 2> ADD TRANDATA HR.*
...
2024-04-06 00:11:56  WARNING OGG-00706  Failed to add supplemental log group on table HR.TEST due to ORA-01031: insufficient privileges
 SQL ALTER TABLE "HR"."TEST" ADD SUPPLEMENTAL LOG GROUP "GGS_76882" ("A") ALWAYS  ENABLE LOGICAL REPLICATION ALL KEYS   /* GOLDENGATE_DDL_REPLICATION */.

Solution:

Connect to the database via sqlplus and grant necessary permission to GG user (ggcw in my case):

$ export ORACLE_SID=orcl1
$ sqlplus / as sysdba
SQL> grant alter any table to ggcw;

Rerun the statement:

GGSCI (rac1.mycompany.mydomain as ggcw@orcl2) 4>  ADD TRANDATA HR.*