MySQL Forums
Forum List  »  Partitioning

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.

Options: ReplyQuote

Written By
November 18, 2010 04:27PM
Re: Restrict users to individual records
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.