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]
