This topic is locked

security on charts

11/11/2008 4:51:05 AM
PHPRunner General questions
R
rainerwolf author

Hi,
i have a problem with the chart advanced security access. (Users can see and edit their own dataonly).
In the result of a chart i see no difference between 'Users can see and edit other user data' and 'Users can see and edit their own dataonly'.
This means, the user can see all the other datas in the chart.
In the same application i create a report with the same access mechanism, and at this point it works very well.
Need help

J
Jane 11/11/2008

Rainer,
thank you for pointing me to this bug.

We'll fix it in the next version.
To make your pages working add following code to the Chart page: Before SQL query event on the Events tab:

if(SecuritySQL("Search"))

$strWhereClause = whereAdd($strWhereClause,SecuritySQL("Search"));

R
rainerwolf author 11/11/2008

Ok, thank you very much