Data feeds to a non-oracle database
Hi All,
We have a business requirement to provide read only access to certain set of tables in our database to our customer.
They need live data as much as possible for reporting/statistical data.
We initially planned to create a USER with restricted profile and select only access to the tables on production database.
But since read-only accounts are not very safe (as they can still LOCK the table or issue a select for update), we did not want to take that risk on the production database. BTW, we are using 10.2.0.2. The active dataguard would be a great solution for our scenario if we were on 11g.
We have a business requirement to provide read only access to certain set of tables in our database to our customer.
They need live data as much as possible for reporting/statistical data.
We initially planned to create a USER with restricted profile and select only access to the tables on production database.
But since read-only accounts are not very safe (as they can still LOCK the table or issue a select for update), we did not want to take that risk on the production database. BTW, we are using 10.2.0.2. The active dataguard would be a great solution for our scenario if we were on 11g.
0