I am working as an Oracle developer. I use Data Guard to replicate production Oracle database. I need to grant read access to replica DB and at the same time need to restrict that same login gaining read access to production. Since the data guard replicates everything is there any way I can apply this restriction in the production databases? should I look into to database server inbound port restrictions? any thoughts on this are greatly appreciated.
Thanks & Regards
Camillelola