List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 27 1999 3:36pm
Subject:Re: Question about permissions
View as plain text  
At 4:49 PM +0200 11/26/99, <sinisa@stripped> wrote:
>Dmitry Sivachenko writes:
>  > Hello!
>  >
>  > I want to create user 'User' and database 'User' so, that this user
>  > would be able to do anything with that database, and nothing with
>  > something outside his database.  I did the following steps:
>  >
>  > mysqladmin create User
>  > mysql>  grant select,insert,update,delete,index,alter,create,drop on\
>  > User.* to User@localhost;
>  >
>  > BNut after that , this user can see what databases are available 
>on the system
>  > (show databases command works)
>  >
>  > Is it possible to disable this?
>  > What other things this user can see/do outside his database?
>  >
>  > Thank you in advance,
>  > Dima
>  >
>  >
>
>Hi!
>
>Yes, all users can see databases available, but can not see what is in
>them !!
>
>Root of the problem lies in the fact that  there is no such privilege
>that defines a right to see or not see a list of databases.


If you're running MySQL 3.23, you can start the server with the
--skip-show-database option, which prevents unprivileged (non-root)
users from issuing SHOW DATABASES queries or from using SHOW TABLES
on databases to which they do not have access.


-- 
Paul DuBois, paul@stripped
Thread
Question about permissionsDmitry Sivachenko26 Nov
  • Re: Question about permissionssinisa26 Nov
    • Re: Question about permissionsPaul DuBois27 Nov