Re: Show databases shows all even if no rights;

2004-10-17 Thread Paul Fierro
On 10/17/2004 7:12 AM, Michael J. Pawlowsky <[EMAIL PROTECTED]> wrote: > All priviliges for that user in mysql.user are set to N. > I know this is hard to read but here are the outputs from user and db. [snip] > Paul DuBois wrote: > >> At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote: >> >>

Re: Show databases shows all even if no rights;

2004-10-17 Thread Michael J. Pawlowsky
All priviliges for that user in mysql.user are set to N. I know this is hard to read but here are the outputs from user and db. +---++--+-+-+--- --+-+-+---+-+---+--- ---+

Re: Show databases shows all even if no rights;

2004-10-16 Thread Paul DuBois
At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote: I just noticed that a restricted user to only one database can still run "show databases;" and see all the names of the databases in MySQL. You would think that it would only return the databases that that user is allowed to connect to. Is th

Show databases shows all even if no rights;

2004-10-16 Thread Michael J. Pawlowsky
I just noticed that a restricted user to only one database can still run "show databases;" and see all the names of the databases in MySQL. You would think that it would only return the databases that that user is allowed to connect to. Is there a way I can show only those databases that he has