Matthijs Holter wrote:
> Hi!
>
> I'm setting up a multi-user system where I want different users to have
> access to different tuples in the same schema. So that, for instance, userA
> and userB both have access to the schema "Cars (color, age)", but only userA
> has access to "car1 red 12" and userB has access to "car2 blue 1".
>
> Is there any way to set these rights in SQL?
>
> - Matthijs
>
>

Yes. Using views.
http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Don't give access to the table, but create as many views as you need
to implement your profiles, and then give rights to these views
(they could be updatable also).

You can also enforce a constraint
http://www.livejournal.com/users/arjen_lentz/49881.html

ciao
gmax

--
_ _ _ _
(_|| | |(_|><
_|
http://gmax.oltrelinux.com