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
>Yes, all users can see databases available, but can not see what is in
>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