Bug #12197 GRANT should allow several objects to be specified
Submitted: 27 Jul 2005 7:16 Modified: 2 Aug 2009 14:58
Reporter: Carsten Pedersen Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:All OS:Any (All)
Assigned to: CPU Architecture:Any

[27 Jul 2005 7:16] Carsten Pedersen
The current GRANT syntax allows you to specify several users to get access to e.g. one database:

GRANT ALL on db1.* TO user1@localhost, user2@localhost

But, apart from using wildcards, you cannot assign privieleges to several different DBs to a single (or more) users. The following is illegal:

GRANT ALL on accounts.*, products.* TO user1@localhost

This would be useful in several contexts.

How to repeat:
Feature request

Suggested fix:
Feature request
[2 Aug 2009 14:58] Valeriy Kravchuk
Thank you for the feature request. I do not see this feature in SQL 2003 Standard, for example, but it indeed may be useful in some cases.