Hello
We have two databases A and B
There is a application which access db B
All application users have access to db B through sql (cannot block users from sql).
Data changed/inserted in B should come to A
May be we can create db link and synonyms.
How to implement this any suggestions please
Main idea is to prevent the data modification through sql prompt. and db A is setup with regular backups, so data will be backed up.
thanks in advance