PLS-00201: identifier 'DBMS_XSTREAM_GG_ADM' must be declared - GoldenGate
Grant the below privileges to gguser -
exec dbms_goldengate_auth.grant_admin_privilege('<ogg_user>');
grant select any dictionary to <ogg_user>;
grant insert any table to <ogg_user>;
grant update any table to <ogg_user>;
grant delete any table to <ogg_user>;
grant select any dictionary to <ogg_user>;
grant insert any table to <ogg_user>;
grant update any table to <ogg_user>;
grant delete any table to <ogg_user>;
Comments