Alright, guys. Here's a challenging one. I am trying to set up a DB for several managers and a general manager. The general manager will be able to add/delete/edit managers and employees, whereas the managers will only be able to add/edit/delete employees directly under them. I basically want the managers to see employees only directly under them. I was hoping to use the security settings built into PHPRunner, but haven't been able to find a good solution for this. When an employee is placed under a certain manager, there is a field within the employee's information that points to the manager that has permissions for their information. Is there any way without it getting too complicated to set this up so the manager can only see the employees under them, with a general manager being a "power user"? Any help would be greatly appreciated.
I am using PHPRunner 4.0 Build 259, PostgreSQL 8.2, PHP 5.2.2