OGG-02061 User gguser does not have the required privileges to use integrated capture

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;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply