Posted by Gary Hasler on 05/30/07 17:05

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?

• Next in forum: Re: How do I give dealers access to only their records
• Prev in forum: Re: How do I give dealers access to only their records
• Thread view: Re: How do I give dealers access to only their records

[Reply to this message]