From: <sinisa
Date: March 20 1999 12:12am
Subject: Re: Privileges, users and databases
List-Archive: http://lists.mysql.com/mysql/658
Message-Id: <14066.59360.986506.467149@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Paul DuBois writes:
 > At 6:59 PM -0600 3/18/1999, <sinisa@stripped> wrote:
 > >Levy Carneiro Jr. writes:
 > > >
 > > > 	Hi,
 > > >
 > > > 	I've created a user in mysql server and a database for him. The
 > > > privileges in mysql database at user table are ok for this user. What I
 > > > have to do to limit this user to see only this database?
 > > >
 > > >
 > > >
 > > > 	Thanks,
 > > >
 > > > _______________________________________
 > > > Levy Carneiro Jr.	<levy@stripped>
 > > >     Sao Paulo       -       Brasil
 > > >      *** Jesus loves you !!! ***
 > > >
 > >
 > >Hi!
 > >
 > >Simply, set all of enum fields in user table (select_priv,.....) to
 > >'N' and in db table set corresponding enum fields to 'Y'.
 > >
 > >Even better if you are using 3.22.11 or later, use GRANT syntax to do
 > >it. First GRANT  (e.g.) file on *.* to user identified by password,
 > >and then grant select, insert, .. .on db.* to user.
 > 
 > 
 > Wouldn't GRANT USAGE be better than GRANT FILE, particularly for
 > an ordinary user?  FILE is one of those privileges you want to
 > be particularly careful about.
 > 
 > --
 > Paul DuBois, paul@stripped
 > Northern League Chronicles: http://www.snake.net/nl/


Well, you are right about that !!!

Sinisa