List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 3 2011 10:25am
Subject:Re: Allowing all users to access a specified database
View as plain text  
While it does not support wildcards, it does support an empty username field. A subtle
distinction :-) Simply grant access to ''@'%'.

----- Original Message -----
> From: "Mark Goodge" <mark@stripped>
> To: mysql@stripped
> Sent: Friday, 3 June, 2011 12:03:56 PM
> Subject: 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

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
Allowing all users to access a specified databaseMark Goodge3 Jun
  • Re: Allowing all users to access a specified databaseJohn Daisley3 Jun
    • Re: Allowing all users to access a specified databaseMark Goodge3 Jun
      • Re: Allowing all users to access a specified databaseJohn Daisley3 Jun
        • Re: Allowing all users to access a specified databaseJohan De Meersman3 Jun
  • Re: Allowing all users to access a specified databaseJohan De Meersman3 Jun