RE: [PHP] sharing records with assigned users
| From: | Jay Blanchard | Date: | Thu, 26 Aug 2004 17:53:55 +0000 |
| Subject: | RE: [PHP] sharing records with assigned users | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-194821@lists.php.net to get a copy of this message | ||
[snip]
If, in the table I'm storing my records, I create a field which stores
the
Users allowed access to that particular record, then in case of multiple
users, that single field will hold multiple user names... Which is a
problem
for me. And I might be applying a very wrong approach, logically, which
is
why I came forward for some assistance.
[/snip]
use a column for user levels (you'll only have a few) in the record and
then add a column in the user table that designates what level that user
is.
RECORD TABLE
Record ID UserLevels
RecordFoo admin, user, read-only
USER TABLE
User Level
Bob user
Junkie admin
Sue read-only