List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 11 2001 5:49pm
Subject:Re: no rights on a spec db,but -show databases- still shows it
View as plain text  
mysqladmin variables


I believe it is safe_show_database or some-such.

Marco Kammerer wrote:

> 3.22.38
> 
> Hello guys
> 
> I figured out how I can set up different user that are able to work
> on their own dbs.
> 
> here is my command to add a db and a user;
> 
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
> bernduser@LOCALHOST IDENTIFIED BY '1234'
> 
> But a questions:
> when I have added the user with root, log out and log in with the
> user bernduser, I am able to see all databases (just the names)
> is there a way to cut this? Of cource he is only able to work in his
> own, but I only want him to see his own db bernddb.
> 
> Thanks Marco
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread79129@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
no rights on a spec db,but -show databases- still shows itMarco Kammerer11 Jul
  • Re: no rights on a spec db,but -show databases- still shows itGerald Clark11 Jul