access privileges

I'm having a certain user, say 'mike', which i would only give access to
databaseA. Mike should also only see databaseA in the output of 'show
databases'. Unfortunately, mike now sees all databases available if he
issues the command.

How do I prevent this? How do I make sure mike sees only databaseA if
he issues the 'show databases' command?

Tnx,
Bart

--
"Share what you know. Learn what you don't."

"Bart Vandewoestyne" <MyFirstName.MyLastName@telenet.be> wrote in message
news:1111873102.708001@seven.kulnet.kuleuven.ac.be ...
: I'm having a certain user, say 'mike', which i would only give access to
: databaseA. Mike should also only see databaseA in the output of 'show
: databases'. Unfortunately, mike now sees all databases available if he
: issues the command.
:
: How do I prevent this? How do I make sure mike sees only databaseA if
: he issues the 'show databases' command?
:
: Tnx,
: Bart
:
: --
: "Share what you know. Learn what you don't."

Make Mike less important. That is to make him like a guest.

2-lips.

hey
i only just found this forum so sorry if this comes too late!

i would revoke all of mikes privileges with:
revoke all on * from mike;
then grant him access to that table only.
grant select on databasename.tablename to mike.

havn't tried it but logically it should work.

...nokturnal