Shnokey
|
| Posted: 05/25/2003, 7:02 AM |
|
I am new to this - so bear with me....
I am trying to create a portal environment where users can see only records based on their security - I understand how to change security through CC on the high level (admin/user/ect) but Im trying to set this up where all can log in - but based on your name - you can only see limited records. For example - I want John to see record 1,3,5 - and adjust this through the admin section - set up the "add new record" in the admin section to include a field to select the people I want to view the record. Then I can add or remove an individual - not a group - from seeing a single record.
Am I lost - or on the right track?
|
|
|
 |
Shnokey
|
| Posted: 05/28/2003, 2:41 AM |
|
Any Thoughts??????
|
|
|
|
Hamilton
|
| Posted: 05/28/2003, 4:53 AM |
|
You need to create another table - the structure would be something like this;
Alternatively, it may be better to say who cannot view the record rather than who can.
This way, everyone see's it by default and a select few are deemed - not to see it.
Table: RecordLimiter
id, int autonumber/identity
article_id, int
User_ID
You will then need to do a join with your other tables
hope this helps.
|
|
|
|
|
