This topic is locked

Security question

5/25/2009 7:43:45 PM
ASPRunnerPro General questions
W
wisdom2009 author

Hi,
I have table that holds information, each user are allow to see their own information and their supervisors can see for everyone, I was able to use the security advanced and now users can only see their own. The only issue that I have more than 4 teams and each has supervisor, the supervisors are allowed to see only their agent. How can do that using one table that holds every one???
Thanks

J
Jane 5/26/2009

Hi,
you can create custom view on the Datasource tables tab for supervisors only and set up another permissions for this view on the Security tab.

W
wisdom2009 author 5/26/2009

It did not work, I may doing it wrong i created a view and a set up security using adcanced and called the group team but the issue is that all supervisors can see others team. i would like each supervisor see thier own team.

J
Jane 5/27/2009

It's difficult to tell you what's happening without seeing actual files.
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.

W
wisdom2009 author 5/27/2009

I think I know why it did not work, I did use the Advance security and checking the box Users can edit and see their own data only and I match it by team field. The issue was with supervisors that have more than one team. Example when a supervisor has team Inbound and team outbound, the security does not work because it does know what team to use, but if supervisor have only one team it does work. Is there a way to solve this???

Sergey Kornilov admin 5/27/2009

Yes, there is a way to solve it.
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. It' impossible to tell what's wrong without seeing your database and project.