This topic is locked

Different user permissions

3/17/2005 1:42:57 AM
ASPRunnerPro General questions
bnphillips author

Am I able to accomplish the following in step 2.
step 1. User can see/edit only his information.
step 2. Another user (with an additional password and/or other method??) can view/print/export User in step 1's information. (but only user in step 1's information)(he would not be able to see other's info)
This user would would need other password(s) and/or other method?? to view/print/export other users information.
My attempt here is to pass along confidential info to a third party but not have that same third party have the ability to edit original users record.
thank you in advance

-bnp

admin 3/17/2005

Hi,
here is how you can do this:
Login table:
OwnerID Username Password

----------------------------------

1 UserA A

1 UserB B
Main table:

OwnerID Data

----------------------------------

1 ...

1 ...

2 ...
Use Users can see and edit their own data only option. Both users will be able to see the same set of data because OwnerID field is the same.
Create two permission groups with different set of permissions.
I hope this helps.

bnphillips author 3/17/2005

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3759&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' /> thank you for your prompt reply.

-bnp