List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:March 20 1999 12:12am
Subject:Re: Privileges, users and databases
View as plain text  
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
Thread
Privileges, users and databasesLevy Carneiro Jr.18 Mar
  • Privileges, users and databasessinisa19 Mar
    • Re: Privileges, users and databasesPaul DuBois19 Mar
      • Re: Privileges, users and databasessinisa20 Mar