2. PHPRunner General questions
  3. [SOLVED]  Using Advance security settings
This topic is locked
[SOLVED]

 Using Advance security settings

 		7/31/2019 7:59:29 AM
PHPRunner General questions
A
 anzac author

I am using advance security settings to restrict users to view or edit records in a table, but instead using user ID, I have added one column, column project id as reference as owners id, consist several project id (can be one or more)

The scenario is:

One user assigned several project and I want to make the user be able to access one or more projects that assigned.

for example: the project id column in users table will have data like (1,2,6) and the reference table (project table) have data like 1 or 2 or 3 etc. the user that have record 1,2,6 can access the project record

that have id 1, id 2 and id 6.

Any idea how to use the advance security settings to implement this case?
Thank you for any ideas or suggestions.
Sergey Kornilov admin 8/3/2019

No, it is not possible to use Advanced Security in this case, it only works with a single ID. However, you can mimic Advanced Security behavior using the technique explained in this article: https://xlinesoft.com/phprunner/docs/dynamic_sql_query.htm
The kind of WHERE clause you looking for is as follows:

WHERE id in (1,2,6)
A
 		anzac author 8/6/2019

Thank you for the explanation, will try to find solution based on your pointer.



No, it is not possible to use Advanced Security in this case, it only works with a single ID. However, you can mimic Advanced Security behavior using the technique explained in this article: https://xlinesoft.com/phprunner/docs/dynamic_sql_query.htm
The kind of WHERE clause you looking for is as follows:

WHERE id in (1,2,6)