2. PHPRunner General questions
  3. view own records by group of users
This topic is locked

view own records by group of users

 		10/6/2006 7:22:06 AM
PHPRunner General questions
B
 bluestrikealpha author

Hi guys,
I do not seem to get it right. With PHP runner 3.1 I am building a database as an example for computer maintenance.

My clients who buy the computers all have subdivisions in different city's and below that departments and several employees who have to see all computers in that department, and managers who need to see by location and company headquarters have to see all of their own locations including departments.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3544&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> The problem that I still have that I have made a Client number in the users table and made a master relation with the company table with the same Client number field. All other tables have thet client number field.

When I insert a new computer with Client number "1234" . The user that logins with clientnumber "9999" still can see data with clientnumber "1234" eventhough I have set security on "Users can see and edit their Own data only"and Users table and Master table with the same "Client number" field name.

How can I give an employee from an department only his/hers data and How do I define a master table for the complete database?
Quite a long story......but I hope you can help.
Thanks
B
 		bluestrikealpha author 10/6/2006

OOps I've solved one thing; forgot to link every table with the users table in security.So seeing data from another clientnumber is solved (i think)

The other questions still remain valid.
J
 		Jane 10/6/2006

Dion,
I'm not sure that I understand you correctly.

Please give me more detailed description of what you need to achieve.

What does it mean "define a master table for the complete database"?
B
 		bluestrikealpha author 10/6/2006

Hi Jane,
Forget the master table issue, I've solved that, However, how can I make an architecture where all employee's of one department can only see the data from their department only instead of all departments in one company and the general manager of the division can see all the departments, but not other divisions within the company group. Am I making sense here?
J
 		Jane 10/6/2006

Dion,
I see what you saying.

You can create some groups of security on the User group permissions dialog on the Advanced security settings dialog on the Security tab.
Also you can see the "How to use security settings" PHPRunner tutorial here:

http://www.xlinesoft.com/phprunner/php-database.htm#