MySQL Forums
Forum List  »  Quality Assurance

Allow user to run queries ONLY if 'WHERE' is specified.
Posted by: Maxime Monteiro
Date: July 13, 2011 02:35PM

Hello everyone, new on the MySQL Forums but been using MySQL since quite a while - simply the best database software.

One thing I'm wondering...

Using Navicat, I'm able to set privileges of an user so that he can select, update, etc, only on certain database/table/columns.

That's great for security purposes, however there's one thing I'm wondering about. Let's say I have a table called X, with a column called Y and another one called Z.

I allow my user to run update queries on the column Y, however, I don't want him to be capable of sending queries such as UPDATE x SET y = '';.

I'd like to allow only queries such as UPDATE x SET y = '' WHERE z = '';

Anyone knows if this is possible?

Thanks in advance for any comment!



Edited 1 time(s). Last edit at 07/13/2011 02:36PM by Maxime Monteiro.

Options: ReplyQuote


Subject
Views
Written By
Posted
Allow user to run queries ONLY if 'WHERE' is specified.
2186
July 13, 2011 02:35PM


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.