Re: gourp users

On 17-12-2014 16:25, Remigio wrote:
> hi,
> I'm using a mysql db as backend of some office applications.
> There are over 40 users which connect to the database and I'd like to group them into 4 or 5 groups for manage their privileges and tables access rights.
> Is there a way to do this?
> Thank you very much
>
> __
> Remigio
>

You should be able to define table(s) which defines the groups and their members.

After that you should be able to define a trigger which updates all members of a group when the privileges of a member is changed. Received on Wed Dec 17 2014 - 19:55:40 CET