It doesn't. That was one of the multiple wildcard variations I
already tried.
David
On Oct 12, 2006, at 3:13 PM, Anders Lundgren wrote:
I think you should try % that is used as wildcard instead for one
or many characters. Granting on 'foo_%' might work.
Regards,
Anders
--
Anders Lundgren
Master Software Engineer
Viba IT Handelsbolag
Web: http://www.vibait.se
David Felio wrote:
Assume database 'biggie' with 15 tables, 10 of which start with
'foo_'. I want the user 'foouser' to have access only to those
tables that begin with 'foo_'.
I'm hoping that I am just being blind because I don't see anything
in the manual or in the MySQL book on granting to multiple tables
at once and the * wildcard appears to only work by itself, not
when appended to a string (i.e. I can't do "grant select on
biggie.foo_* to 'foouser'..."). I've tried multiple variations of
wildcards, to no avail.
Please tell me I'm not going to have to explicitly grant privs to
each table. There are actually several set of tables for a total
of several hundred tables to which I will need to apply permissions.
Thanks.
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
