Bug #13131 Creation of user groups
Submitted: 13 Sep 2005 7:44 Modified: 13 Sep 2005 10:25
Reporter: Frederic MASSOT Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:4.1.11 OS:Linux (Debian Sarge/i386)
Assigned to: CPU Architecture:Any

[13 Sep 2005 7:44] Frederic MASSOT 
Description:
Hi,

Can you add to the MySQL database server the management of the user groups, like PostgreSQL support (http://www.postgresql.org/files/documentation/books/aw_pgsql/node176.html) ?

This functionality is very practical when there are several developers to work on one or more database.

Regards.

How to repeat:
It there no SQL commands to create user groups.
[13 Sep 2005 10:25] Valeriy Kravchuk 
Thank you for the feature request. I argee that something like groups (or, even better, roles, like in Oracle, Informix etc.) support is needed for the environments with the large number of users with similar business roles accessing the same database objects.

There are plans already to add additional external authentication methods to MySQL, that can be used to solve the same management problems. But their priority is not very high now, so I can't tell you really in what version nubmer these will be added.
[30 Sep 2008 14:26] Konstantin Osipov 
WL#988 Roles
[22 Dec 2010 13:00] MySQL Verification Team 
This looks useful: http://code.google.com/p/securich/