Granting Read-Only access to an existing Oracle Schema
- by Andrew
Hi, we've got an Oracle 11g Schema that our application uses to select, insert and update, but we've had a request from one of our customers to provide read-only access to the same base tables and views owned by the application.
Other than synonym'ing all of the application owned tables into a new account (or making the synonyms public), how would I go about doing this?
Any help or pointers to the approach or Oracle feature I should be looking at would be most appreciated, thank you!