Re: grants to multiple DBs at once

That's my fault. It does work with 4.0.18. (The manual is usually pretty good at specifying when something is 4.1 only, by the way.) You need to quote the db string with backticks, not single quotes (as I did in my example). So, you would use GRANT SELECT ON `dev\_%`.* TO [EMAIL PROTECTED

Re: grants to multiple DBs at once

Hi Michael, Thanks for the reply. It doesn't work, at least not with 4.0.18. I also tried without the _ to simplify the case, but the grant statement isn't wild about the wildcard. :) The docs you list are for 4.1. I guess I will have to wait until 4.1. :)

Re: grants to multiple DBs at once

This is documented in the manual: Note: the '_' and '%' wildcards are allowed when specifying database names in GRANT statements that grant privileges at the global or database levels. So, if dev is the prefix, you need: GRANT SELECT ON

Re: grants to multiple DBs at once

- Original Message - From: "Brian C. Hill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 16, 2004 4:22 PM Subject: grants to multiple DBs at once > I have about 20 DB's with the same prefix. > > How can I do something like &g

grants to multiple DBs at once

I have about 20 DB's with the same prefix. How can I do something like GRANT SELECT ON dev_*.* I have seen examples for the _other_ DB software, like msql, that does something like: SELECT 'GRANT SELECT ON '+name+' TO webuser;' from s