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

 Advance security setting

 		3/23/2011 6:29:06 PM
PHPRunner General questions
C
 choanhemnhe author

Hi Members,

Regarding to Advance security setting, if the second option is selected "User can see and edit their own data only", then only the owner of a record may alter that record. This means if a records created by user name JohnWin only user with user name JohnWin ID can view and alter that records.
Is there any way for that any user name which begin with Jo or Joh or John or JohnW ... may view and edit records created by JohnWin ?
In SQL query this is equivalent to
SELECT FROM tabel1 WHERE owner='Joh%'
I want it be like this
SELECT FROM tabel1 WHERE owner LIKE 'Joh%'
any helps Please!!!!

Thank you,
Sergey Kornilov admin 3/23/2011

You can implement your own version of advanced security settings. Check this article for inspiration:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
C
 		choanhemnhe author 3/24/2011

Hello,

You are right, I have to build my own security. I believe, the build in security "user can edit and view their own data only" using IF...ELSE conditions to filter the results rather than using SQL queries. If it use SQL queries, it is more simple to alter. Please correct it if I'm wrong.

Thanks