2. PHPRunner General questions
  3. Dynamic Permission Problem
This topic is locked

Dynamic Permission Problem

 		8/26/2010 11:03:49 AM
PHPRunner General questions
U
 utpal2008 author

I have two tables as per below:

  1. login(username,password)
  2. customer(ID,Name,RefID)
    RefID is actually lookup column from 'login' table and 'username' column. I have set option.2 in security settings(Users can see and edit their own data only and username field as the link up field). Now the problem is that whenever a admin user adds a customer in the customer table, the 'RefID' is always taken and inserted as the admin username. When edited the value next time then it becomes OK.
    Why this problem arises?
Sergey Kornilov admin 8/26/2010

This behavior is by design.
When you add a new record in 'Users can see and edit their own data only' mode this record is automatically assigned to the current user.
If you want admin to create new record assigned to other users create a new custom view on Datasource tables screen and do not apply 'Users can see and edit their own data only' option to this view. Then use 'User group permissions' to allow access to this view to admin only.