MySQL Forums
Forum List  »  Security

Advanced Search
New Topic

Re: User Roles or Groups in MySQL
Posted by: Bill Karwin
Date: May 22, 2006 08:57PM

There is no support for groups of users or SQL ROLES (which are groups of privileges) in MySQL.

It is not mentioned in the list of new features in 5.0, or in the roadmap of future development for MySQL 5.1 or 5.2.

http://dev.mysql.com/doc/refman/5.0/en/mysql-5-0-nutshell.html
http://dev.mysql.com/doc/refman/5.1/en/mysql-5-1-nutshell.html
http://dev.mysql.com/doc/refman/5.1/en/mysql-5-2-plans.html

There are a couple of bugs that mention roles, for example:
http://bugs.mysql.com/bug.php?id=13131

But these also do not identify the priority or an intention to implement the feature in any given release of MySQL.

One old bug states that MySQL 5.0 was to implement SQL roles, but obviously those priorities changed.

http://bugs.mysql.com/bug.php?id=895

Regards,
Bill K.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
User Roles or Groups in MySQL
44733
Sajid Mansoori
September 27, 2005 12:51PM
Re: User Roles or Groups in MySQL
19132
Rafael Dalma
January 19, 2006 07:03PM
Re: User Roles or Groups in MySQL
16127
Gert Vernhout
May 22, 2006 03:21PM
Re: User Roles or Groups in MySQL
14908
Bill Karwin
May 22, 2006 08:57PM
Re: No User Roles or Groups in MySQL but MySQL MaxDB has roles
10852
Tito Brezovacki
December 14, 2006 02:41AM
Re: No User Roles or Groups in MySQL but MySQL MaxDB has roles
9130
Leandro DUTRA
May 05, 2009 07:54AM
Re: User Roles or Groups in MySQL
7897
J Armstrong
March 31, 2009 02:00AM
Re: User Roles or Groups in MySQL
7427
Darren Cassar
June 15, 2009 07:24AM
Re: User Roles or Groups in MySQL
7367
Darren Cassar
June 15, 2009 07:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.