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/
