Error:
OGG-02061 User gguser@localhost:1521/pdb1 does not
have the required privileges to use integrated capture.
Solution: For integrated capture give special permission
BEGIN
DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(
grantee => 'GGUSER',
privilege_type => 'CAPTURE',
grant_select_privileges => TRUE
);
END;
/
Rest of the command used for configure GGUSER
-- Basic connectivity
GRANT CONNECT TO GGUSER;
GRANT RESOURCE TO GGUSER;
-- GoldenGate capture privileges
GRANT ALTER SESSION TO GGUSER;
GRANT SELECT ANY DICTIONARY TO GGUSER;
GRANT FLASHBACK ANY TABLE TO GGUSER;
GRANT EXECUTE ON DBMS_LOGMNR TO GGUSER;
GRANT EXECUTE ON DBMS_LOGMNR_D TO GGUSER;
-- Additional logmining access
GRANT SELECT ANY TRANSACTION TO GGUSER;
GRANT LOGMINING TO GGUSER;
-- Prevent space issues
GRANT UNLIMITED TABLESPACE TO GGUSER;