Posted by ZeldorBlat on 05/30/07 17:19

On May 30, 1:05 pm, Gary Hasler <garyhas...@thelogconnection.com>
wrote:
> ZeldorBlat wrote:
>
> ...snip
>
>
>
> > > > I guess basically I'm asking: is there any way to restrict a mySql user;
> > > > or to set a restriction on the table, beyond the built in mySql
> > > > restrictions of SELECT, INSERT, etc.
>
> > > > For example: for user Joe_Blow, the restriction "WHERE `dealer` =
> > > > 'Joe_Blow'" is added to every query? My question is evolving...am I
> > > > looking for something like a "middle-man" between the mySql server and
> > > > the client?
>
> > > If I understand what you are saying, the answer is no. You cannot make a
> > > table in which certain fields are open only to certain people.
>
> > (Top-posting fixed)
>
> > No, but you can create a view that includes an appropriate where
> > clause and give specific users select permission on the view.
>
> A 'view'--what is that?

More information is available in the manual:

<http://dev.mysql.com/doc/refman/5.0/en/views.html>

But the short answer is that they are saved queries that can be used
just like tables. So you might create a view called "JoesQuotes" that
looks like this:

select *
from quotes
where dealer = 'Joe_Blow'

And then grant Joe's user account select permissions on the view (but
not on the quotes table itself). Then, from Excel, Joe can select
from JoesQuotes and be restricted to his records.

[Back to original message]