MySQL User Groups
Posted: Tue Feb 21, 2006 5:38 pm
I need to add user group permissions to a mysql database a la postgres:
...so I can assign group-based privs...
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?
Code: Select all
CREATE GROUP people USER bob, fred, tom;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?