[EMAIL PROTECTED]
> Sent: Wednesday, June 29, 2005 10:27 AM
> To: John Trammell
> Cc: mysql@lists.mysql.com
> Subject: Re: Underscore functions as a wildcard ?
>
> This is not a bug. Mysql uses _ as the single-character
> wildcard, and % as
> the multi-character wildcar
hat version
of MySQL are you running?
-Original Message-
From: Jeroen Bosch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 29, 2005 6:59 AM
To: mysql@lists.mysql.com
Subject: Underscore functions as a wildcard ?
We stumbled upon the following 'feature' of MySQL:
If, for
Hello.
Could you give a test case? For example I've done these steps, and user
u1 couldn't create tables in other databases.
grant all privileges on `user\_data`.* to 'u1'@'localhost' identified by
'u1';
grant select on user2data.* to [EMAIL PROTECTED];
Then I've logged in as u1.
u
6:59 AM
> To: mysql@lists.mysql.com
> Subject: Underscore functions as a wildcard ?
>
> We stumbled upon the following 'feature' of MySQL:
>
>
>
> If, for example user 'x' has a database called 'user_data' he
> is able to
> create a
We stumbled upon the following 'feature' of MySQL:
If, for example user 'x' has a database called 'user_data' he is able to
create a table called user2data and so on without create privileges.
It looks like the underscore is used as some kind of wildcard, now is the
question: is this correct o
