Re: users Permission Oddity

[Paul DuBois]

At 20:17 -0700 8/28/02, neal wrote:
>Here's an odd one.  I am connecting via JDBC using an account that
>apparently has no permissions granted to it ... even select_priv (straight
>Ns across the table).   And yet ... I can do select statements with it ...
>no problem.
>
>How could that be?

Probably because you're being validated as a different user than you
think.

>
>Is is possible this could be related to the previous issue wherein I was
>able to connect using an account bob@% where a password was specified int he
>account, even though I provided no password while logging in?
>
>I should note that I am using MySQL 4.0.1 ... perhaps this explains these
>issues????

Not likely.

>
>
>Thanks.
>Neal