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)
artev [ Do, 17 Mai 2007 21:06 ] [ ID #1714022 ]

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/>
];-)
Markus Mann [ Mo, 04 Juni 2007 15:10 ] [ ID #1729537 ]
Datenbanken » de.comp.datenbanken.mysql » two db, one user is limited at the owner also with inject..

Vorheriges Thema: zwei tabellen vergleichen
Nächstes Thema: GROUP_CONCAT in Subquery