2. ASPRunnerPro General questions
  3. Help with permissions
This topic is locked

Help with permissions

 		12/9/2009 8:04:35 PM
ASPRunnerPro General questions
A
 Aussie Mick author

Hello everyone,
I am trying to design a database to deal with injuries in the workplace. Ideally I want all employees to be able to log on and report (log) an incident. I want them to be able to do this without having to put in a username and password. This is all they will be able to do, they should not be able to view any other data.
Then I would like managers to be able to see all the incidents for their region only (with a username and password)
And Senior Managers to be able to view all incidents in the database (with a username and password)
To summarise, what I would like to do is have three different types of security.
Level 1 - ( I don't want to prompt them for a password) - This user will be able to add a new call to the main call log but do nothing else.

Level 2 - These people will be prompted for a password and will have access to all calls in the call log for their region

Level 3 - These people will be prompted for a password and have access to all calls in the call log.
Is this possible and if so how is it best done.
Thanks
Mick
J
 		Jane 12/10/2009

Mick,
use group permissions on the User group permissions dialog on the Security tab for this purpose.

Firstly create Guest account on the Advanced security settings dialog, assign 'add' permissions only for guests on the User group permissions dialog.

Then create two groups: users and admins, assign corresponding permissions for these groups, set up admins as 'admin group'. To filter records on the page turn on User can see and edit their own records only option on the Advanced security settings dialog and choose Region as OwnerID field.
A
 		Aussie Mick author 12/10/2009



Mick,
use group permissions on the User group permissions dialog on the Security tab for this purpose.

Firstly create Guest account on the Advanced security settings dialog, assign 'add' permissions only for guests on the User group permissions dialog.

Then create two groups: users and admins, assign corresponding permissions for these groups, set up admins as 'admin group'. To filter records on the page turn on User can see and edit their own records only option on the Advanced security settings dialog and choose Region as OwnerID field.


Hi Jane, I have tried that, but whenyou click on log in as guest you are not presented with any options to add as it is 'read only' access regardles of the permissions.
J
 		Jane 12/11/2009

Mick,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.