2. ASPRunnerPro General questions
  3. [SOLVED]  users can see and edit thier own data only except for specific access
This topic is locked
[SOLVED]

 users can see and edit thier own data only except for specific access

5/27/2010 5:24:47 PM
ASPRunnerPro General questions
M
 mfred author

In advanced setting, I can designate specific tables to allow users to be able see and edit only their own data. In a current project, I would like to alter that so that it applies except for specific access levels. In the user table, I designate each user with an access level. I would like admin access to be able to see everyone's entries but all others would see only their own. Is that possible?
A
 		ann 5/28/2010

Hi,
to create one access level I advise you to create a ClassID field in the UsersTable. Add Custom view of the TableName table on the Datasource tables tab. Then assign different permissions for main table and this view: choose ClassID as OwnerID for users on the Advanced security settings dialog on the Security tab. Then set up permissions for these pages on the User group permissionsdialog: assign rights for admin to table and for users to "Copy of the TableName". Check "Admin group" option on the User group permissions dialog for admin. Repeat steps in order to create more levels.