From: Paul DuBois Date: March 19 1999 1:51am Subject: Re: Privileges, users and databases List-Archive: http://lists.mysql.com/mysql/552 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 6:59 PM -0600 3/18/1999, 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. > > 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/