Re: Restrict users to individual records
Posted by:
Rick James
Date: November 20, 2010 02:48PM
Probably best to give each client his own database. And give each user his own login that is restricted to that database.
Alternatively, you could not give them access directly to the database. Instead, have a layer of code that they have to go through. In that, you would control logins and access, and limit what they can do with the data.
If they are currently doing arbitrary queries, the layer would be a set-back for them. But, ad hoc queries are a serious threat to the integrity of the system.
Subject
Views
Written By
Posted
3035
November 18, 2010 04:27PM
Re: Restrict users to individual records
1569
November 20, 2010 02:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.