List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 19 1999 1:51am
Subject:Re: Privileges, users and databases
View as plain text  
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/
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