MySQL User Groups

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
benc
Forum Newbie
Posts: 1
Joined: Sun May 01, 2005 10:27 pm
Location: Melbourne AU
Contact:

MySQL User Groups

Post 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?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post 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
(#10850)
Post Reply