At 8:28 AM -0500 5/28/99, Manuel Elgorriaga wrote:
>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: http://www.snake.net/nl/