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
