Mike,
Thursday, March 14, 2002, 7:27:32 PM, you wrote:
MH> I have just recieved a request to build a database using mySQL and I have a
MH> bit of a dilemma.
MH> The database is to be used for relations between
MH> politicians and their constituents,
MH> and I have to have tables for constituents and their information. I would like
MH> to have one main database and not seperate databases for each politician, but
MH> I would like to make sure that they can only see
MH> information on THEIR OWN constituants
MH> and not the constituants of their competitors.
MH> Is there any way to grant permissions
MH> only where the constituency matches theirs? I can do
MH> this easily enough through
MH> the application, but I would like to extend
MH> such security to the database itself.
MySQL privilege system provides privileges on database, table and
column levels. You can specify privileges for your politician on
corresponding databases. For example:
If you have politician "John Johnson" you can set grants for him
GRANT priv_type ON John_database.* TO 'john'@'%' IDENTIFIED BY 'password';
You can read more about privilege system in MySQL at:
http://www.mysql.com/doc/P/r/Privileges.html
http://ww.mysql.com/doc/G/R/GRANT.html
MH> Mike Hillyer
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
