Page 1 of 1

MySQL User Groups

Posted: Tue Feb 21, 2006 5:38 pm
by benc
I need to add user group permissions to a mysql database a la postgres:

Code: Select all

CREATE GROUP people USER bob, fred, tom;
...so I can assign group-based privs...

Code: Select all

GRANT SELECT ON database.table TO people;

I'm about 99% certain mysql doesn't support groups at this stage, but has anyone encountered this problem in the past and willing to share a work-around?

Posted: Tue Feb 21, 2006 6:21 pm
by Christopher
MySQL does not have Group or Role privileges like Postgres. Here is a page that goes through the differences:

http://www.samspublishing.com/library/c ... m=155&rl=1