Posted by Jerry Stuckle on 10/14/06 14:39

toffee wrote:
> Hi all,
>
> i was wondering if its possible to do something with permissions in MySQL so
> that a user can only see a restricted set of data in all the tables?
>
> For example, if I have 10+ tables with data for several teams - how can i
> make it so that a particular team can only see data relating to them? is
> this maybe something that can be achieved with a UDF ?
>
> Kind regards
>
> T
>
>

You can use a view. But you need MySQL 5.0 or later.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]