I'm relatively new to MySQL and am drawing up some ideas for writing a
support/trouble tracking database for my company. I envisioned a single
database with seperate tables for various data I would be storing
(IP/Connection info table, Machine Inventory Table, etc). Each table would
have data for all the clients, and each client would have their own login
(via web/php) to view their information. However, it doesn't seem that I can
restrict a given mysql user to access only those rows of data that are
relevant to their company. It seems that I can only restrict user access to
certain tables, which would seem that I would have to have a seperate table
per client/company. This doesn't seem to be an ideal way of storing the data
I would be collecting though. Is there some other means of restricting
access in the desired way or am I being too ambitious in my goals of having
the client data accessible via a per user/login basis? Thanks for your time.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
