List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 28 1999 5:04pm
Subject:Re: Group permissions in grant tables...
View as plain text  
At 8:28 AM -0500 5/28/99, Manuel Elgorriaga wrote:
>Hi all,
>I was wondering how could I deal with group permissions in MySQL. I have
>several users with the same rights for a set of different databases, and
>I don't want to input each user/database combination over and over
>again. But to my knowledge, MySQL doesn't support groupping of users
>(and occasionally for databases too) and assigning specific rigths to
>each group. Wildcards don't work for the user-tables, so there's no way
>of grouping users with a simple name-prefix (e.g. group1-username). So,
>my question: is there any workaround for this situation or am I just
>missing some basic point about it? And will this item be addressed in a
>future release of MySQL?

You could define a user name that you just treat as a group name and have them
connect as that "user".

Paul DuBois, paul@stripped
Northern League Chronicles:
Group permissions in grant tables...Manuel Elgorriaga28 May
  • Re: Group permissions in grant tables...Paul DuBois28 May
  • Re: Group permissions in grant tables...Christian Mack28 May