Dear Experts,
We have 2 node RAC.
Source and Target Databases are running in the same container.
We've created C##GGADMIN at CDB Level and created another user as "GGADMIN" for HRMS2CORE Database (PDB)
C##GGADMIN --- > Common user at Container Database
GGADMIN ---> For a Specific Pluggable DB (HRMS2CORE).
>> User Aliases created for both user accounts
===================================
GGSCI (hrms2-ora-pt01 as C##GGADMIN@hrms2db2) 17> alter credentialstore add user C##GGADMIN@HRMS2,password C##GGADMIN, alias GG_HRMS2DB
Credential store altered.
GGSCI (hrms2-ora-pt01 as C##GGADMIN@hrms2db2) 18> alter credentialstore add user ggadmin@HRMS2CORE, password ggadmin, alias GG_HRMS2CORE
Credential store altered.
GGSCI (hrms2-ora-pt01 as C##GGADMIN@hrms2db2) 19> info credentialstore
Reading from credential store:
Default domain: OracleGoldenGate
Alias: GG_HRMS2DB
Userid: C##GGADMIN@HRMS2
Alias: GG_HRMS2CORE
Userid: ggadmin@HRMS2CORE
Question :
=======
If i want to enable trandata for a table / schema (which is part of the PDB) Database (HRMS2CORE)
Which DBLogin access is required ?
CDB DBLOGIN i.e. GG_HRMS2DB or
PDB DBLOGIN i.e. GG_HRMS2CORE
Thanks