Hi,
Make an include file with your connection function and set the proper
permission and call it in your cgi script.
If you want to restrict table to users it can be done with a simple mysql
stmt. It would look something like:
GRANT previleges_you_want_give ON db_name.table_name TO
your_user_name@localhost;
Thanks,
James R. Butzen
NEBIS Tech
http://www.nebis.com
-----Original Message-----
From: sachin shetty [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 5:41 PM
To: [EMAIL PROTECTED]
Subject: Restricted access to Mysql through a CGI script
Hello
I am accessing a mysql database through a CGI script , but wouldnt like to
give the passwords in the script.The functionality involves restricting
access to tables in the database for different users.Is there a way
through which restricted view to the tables can be given via a
configuration scropt.The web page is protected through .htaccess.I looked
through some documentation of mod_auth , but couldnt get much info on
table restriction.
I would appreciate if you can suggest me a solution for this problem
Thanks for your time
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
