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.
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
