2. PHPRunner General questions
  3. Web Reports Security
This topic is locked

Web Reports Security

 		6/19/2013 5:02:21 PM
PHPRunner General questions
author

Hi I have set up my database tables only to allow users to review data based on their ID. I have also set up a number of sql queries in the enterprise edition of php runners web reports extension. I am using PHPrunner 6.2.
How can i define that users only see their data in the web reports sql i.e where userid = ".$_SESSION["user_id"]. At the moment if i set up a query they can see all their data and every one else's data.
Thanks in advance
7542 6/21/2013

HI
To clarify. I am using web reports, and need the custom SQL i have created to be where user_id = ".S_SESSION....
I have tried '".$_SESSION .... <?php echo $_SESSION.... i have also tried with session start in the php tags
Any ideas???. Their must be a way of modifying the charts so that users can only see their own data?
Thanks in advance
Sergey Kornilov admin 6/21/2013

Unfortunately there is no such an option in web reports. You can only do that in regular reports.