2. ASPRunnerPro General questions
  3. Guest/User permissions
This topic is locked

Guest/User permissions

 		8/9/2005 9:19:27 AM
ASPRunnerPro General questions
L
 larryebass author

"Users can see and edit their own data only"

When I select this option: Any attempt to log in as Guest

return an error: User does not have permission to access this table.
How do I get around this...

I would like Guest to view (read Only) the LIST data,

But allow the USER login to view and edit their own data only.
sparkg 8/9/2005

I ended up making a new project for each group. So I had 3 sets of code - admin, viewonly, and usersRestrictedByCompany. There is a main menu page with 3 links to each of the groups.

There is a table for each set of users Users-Admin, Users-ViewOnly, and Users-Production. Each has 3 columns, Username, Password, Company.

These tables are only accessible and editable by Admin.

This allows you to set up ViewOnly users under control. We couldn't even have just anybody be guest - it had to be controlled.

We used the Advanced security feature to match main tables records company column to the company column in the user tables.
admin 8/10/2005

Hi,
there is no point to use Guest and "Users can see and edit their own data only" options together because guest hasn't any own records.
You can create two separate projects for Guest access and for registered users using corresponding security settings.

Put these projects in two different output directories. So guests and registered users will use different URLs for database access.
L
 		larryebass author 8/10/2005

Thank you!