Hello.
Maybe these links will be helpful: http://dev.mysql.com/doc/mysql/en/privilege-system.html http://dev.mysql.com/doc/mysql/en/grant.html Russ <[EMAIL PROTECTED]> wrote: > I run SuSE 9.1 with mysql 4.0.18. I have two databases plus the two created > by > my sql. I working on a new security program for one of the databases where > the user will login to a webpage for information. The program is presently > running on localhost. When I added the necessary user id and password for the > program I noticed it shows up in all of the database priveliges. Is there a > way to limit it to one database and specifically on table? > > Connection code: > actual user and password are in code. > Only SELECT authority is on the database > > $conn = mysql_connect("localhost", "username", "password") > or die(mysql_error()); > mysql_select_db("Lions",$conn) or die(mysql_error()); > > This works. But I don't want someone to beable to read the other databases or > tables in the Lions database. > > Any help would be appreciated!!! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]