Most of the privileges that are needed for Extract and Replicat to operate are granted through the DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE package.

The first example is the default, which grants to both Extract and Replicat. The second shows how to explicitly grant to either Extract or Replicat (in this case, Extract).

GRANT_ADMIN_PRIVILEGE ('ggadmin')
GRANT_ADMIN_PRIVILEGE ('ggadmin','exte');

The following example shows Extract on Oracle 12c multitenant database:

BEGIN  
DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE 
(GRANTEE => 'c##ggadmin',  PRIVILEGE_TYPE => 'CAPTURE',  GRANT_SELECT_PRIVILEGES => TRUE,  DO_GRANTS => TRUE,  CONTAINER => 'ALL'  ); 
END;

Optional Grants for dbms_goldengate_auth.grant_admin_privilege

This procedure grants the privileges needed by a user to be a Oracle GoldenGate administrator. See DBMS_GOLDENGATE_AUTH in Oracle Database PL/SQL Packages and Types Reference for more information.