1. Actually we are in middle of setup of GG. Where gg is implemented by me but will be maintained by application dbas. I even spend a tar on metalink on i to figure out these privs. There is no need to grant dba to the gg user. Neither 8n the db nor on the linux level when using integrated capture method. Which is my goal in project now.

    • Hi Mathis,

      Yes you are absolutely right. It is not required to grant a DBA privilege. However if all tablee of a schema need to be replicated please make sure that you explicitly grant the SELECT privilege on the new table to the GG user. If not no data will be extracted from the new table and no error will returned.

Leave a Reply

Your email address will not be published.

Receive Expert Articles via Email

Database    GoldenGate