2. PHPRunner General questions
  3. Limiting Views/Reports
This topic is locked

Limiting Views/Reports

 		12/10/2007 3:42:55 PM
PHPRunner General questions
E
 ekrocker author

I am creating a claims database and would like to be able to let people login and see views/reports.
I have the security enabled and have created roles within the mysql table (staff, agent, dealership, etc.)
How can I enable PHPRunner to only let certain roles see special roles?
Example: I have a dealerhship and I only want them to be able to see claims of people who purchases vehicles at their dealership. I see where I can customize the view adding the 'where dealership =" but I want it to be more specific by role.
Any suggestions would greatly be appreciated.
J
 		Jane 12/11/2007

Evan,
to restrict user access use Use can see and edit their own records only option on the Advanced security settings dialog on the Security tab.
E
 		ekrocker author 12/11/2007

The problem that I am still running into is that the role of 'dealership' will not have add, edit, or delete access.

Evan,

to restrict user access use Use can see and edit their own records only option on the Advanced security settings dialog on the Security tab.
J
 		Jane 12/11/2007

Evan,
it's difficult to tell you what's happening without seeing actual tables.

You can post your table structure here or send it to [email=support@xlinesoft.com]support@xlinesoft.com[/email] and I'll help you to setup correct security settings.
E
 		ekrocker author 12/11/2007

You mean a break down of the mysql tables?

Evan,

it's difficult to tell you what's happening without seeing actual tables.

You can post your table structure here or send it to [email=support@xlinesoft.com]support@xlinesoft.com[/email] and I'll help you to setup correct security settings.
J
 		Jane 12/12/2007

Evan,
to export table structure use any MySQL administrative tools (phpMyAdmin for example).