MySQL Bugs: #5754: Please: SCHEMA & GROUP support

Bug #5754	Please: SCHEMA & GROUP support
Submitted:	26 Sep 2004 20:38	Modified:	3 Oct 2008 16:23
Reporter:	Jesus Alviarez	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S4 (Feature request)
Version:	5.0	OS:	Linux (Linux & Windows)
Assigned to:		CPU Architecture:	Any

Description:
You should really try to implement SCHEMA's and user GROUP's like Oracle and PostgreSQL, SCHEMA & GROUP (of users) support are two of the last things MySQL needs to be considered over PostgreSQL.

How to repeat:
You should really try to implement SCHEMA's and user GROUP's like Oracle and PostgreSQL, SCHEMA & GROUP (of users) support are two of the last things MySQL needs to be considered over PostgreSQL.

Suggested fix:
You should really try to implement SCHEMA's and user GROUP's like Oracle and PostgreSQL, SCHEMA & GROUP (of users) support are two of the last things MySQL needs to be considered over PostgreSQL.

Thank you for a useful feature request. I agree, that ROLEs support inside database, as well as some way to associate OS user groups with database roles can be useful. But do not expect this feature to be implemented in any foreseeable future - current MySQL access control system is based on different ideas.

Thank you for writing to us.
Please do not submit two independent requests in the same bug report.
We do plan to support ROLEs (not GROUPs) and SCHEMAs, there is not exact plan yet,
however:
http://forge.mysql.com/worklog/task.php?id=988
http://forge.mysql.com/worklog/task.php?id=2073