you should Managing Users with PHP Sessions and MySQL
as per this tutorial:
http://www.webmasterbase.com/article.php?aid=319
then you will always have the $userid or $uid (or whatever you wanna call
it )from LOGIN when you need it as a key to restrict a given mysql user to
access only those rows of data that are relevant to their company.
Ken
----- Original Message -----
From: "o o" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 2:47 PM
Subject: Design/Permissions Question
> 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
>
>
---------------------------------------------------------------------
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
