Mark Goodge Allowing all users to access a specified database
Jun 03, 2011; 11:03
Mark Goodge
Allowing all users to access a specified database
Hi,
I have a database server with multiple users and multiple databases. I have a situation where I want to allow any user to connect to a specified database.
Unfortunately, the documentation has this to say:
"MySQL does not support wildcards in user names."
Which means, that, although I can use this syntax to grant access for a user to all databases:
GRANT SELECT, INSERT, UPDATE, DELETE ON * TO 'someuser'@'%';
I can't do something like this to grant all users access to a database:
GRANT SELECT, INSERT, UPDATE, DELETE ON mydyb TO '%'@'%';
So, my question is this: How can I allow any user to use a specific database, without individually granting them all access?
The reason I want to be able to do this is that the server hosts a large number of individual ecommerce sites running on the same core software. Each site has its own database for products, customer data, etc, which is only accessible to that site. But each site also needs to be able to access a single, server-wide database which both stores configuration information for the software that the sites run on and store usage statistics for each site which can be accessed by the server admins without needing to have access to each site's own database.
Clues, anyone?
Mark -- Sent from my Babbage Difference Engine http://mark.goodge.co.uk http://www.ratemyairport.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Jun 03
John Daisley Re: Allowing all users to access a specified database
Jun 03, 2011; 11:24
John Daisley
Re: Allowing all users to access a specified database
Jun 03
Johan De Meersman Re: Allowing all users to access a specified database
Jun 03, 2011; 12:25
Johan De Meersman
Re: Allowing all users to access a specified database
Jun 03
Mark Goodge Re: Allowing all users to access a specified database
Jun 03, 2011; 11:47
Mark Goodge
Re: Allowing all users to access a specified database
Jun 03
John Daisley Re: Allowing all users to access a specified database
Jun 03, 2011; 12:32
John Daisley
Re: Allowing all users to access a specified database
Jun 03
Johan De Meersman Re: Allowing all users to access a specified database
Jun 03, 2011; 13:40
Johan De Meersman
Re: Allowing all users to access a specified database
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!