2. PHPRunner General questions
  3. Set Security for one table
This topic is locked

Set Security for one table

 		5/28/2009 3:49:07 PM
PHPRunner General questions
lewisgr author

Hello,
I'm having a problem I set the security on my main table called "Contacts" here I use the LoginID and the AssignedTo so only those who has the assignedto to look and modify the data. Here's the thing I have about 5 child links coming off this. Do I have to set the security on all these pages? Not all of them have AssignedTo. Has someone come to this problem? I would like to hear what you did.
Thanks
J
 		Jane 5/29/2009

Hi,
yes you need to set up security settings for all tables.

You can add AssignedTo field to all detail tables or select it from master table and add to the SQL query for detail table on theList page: Before SQL query event on the Events tab.
lewisgr author 5/29/2009

Hi Jane,
I'm a bit foggy this morning, what do you mean "add to the SQL query for detail table on the List page: Before SQL query"?

Hi,

yes you need to set up security settings for all tables.

You can add AssignedTo field to all detail tables or select it from master table and add to the SQL query for detail table on theList page: Before SQL query event on the Events tab.
J
 		Jane 6/1/2009

You need to add where clause in the List page: Before SQL query event on the Events tab.