two db, one user is limited at the owner also with inject..
if I have two databases, is possible to limit the access of one user only
at the own db and to avoid, for example, if it use a sql injection can in
some way from its db to modify the other?
so at max it can only damage its database.
which setting is preferable use?(example with phpmyadmin)
Re: two db, one user is limited at the owner also with inject..
artev wrote:
>
> if I have two databases, is possible to limit the access of one user only
> at the own db and to avoid, for example, if it use a sql injection can in
> some way from its db to modify the other?
You should set correct privileges:
<http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html>
<http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html>
Bye.
--
Markus Mann <http://www.max93.de/>
];-)