I am looking for a solution for MySQL, I have lots of databases and would like to limit what users see when they type SHOW DATABASES; I would like them to ONLY see the databases they have access to, I know this is supposed to be coming with MySQL v. 4.0.2 but I am wondering if anybody knows of a work around.
Thanks in advance!
-Travis