2. PHPRunner General questions
  3. Advanced Security Settings Page
This topic is locked

Advanced Security Settings Page

 		5/2/2008 8:55:56 PM
PHPRunner General questions
bbarker author

I might have missed a simple concept a while back. If so, then I'm in deep doo doo. Ha!
When setting the Advanced Security Settings, it prompts you to identify the Users Table:OwnerID field and then to relate it to the MainTable: OwnerID field.
What I have overlooked, is that you can select "Current table" at the top of the form. My questions are:

  1. Do you have to select EVERY table in your database and establish the appropriate linkage?
  2. Does this mean that every single table (eg. Main Table) needs to have a field that links back to the Users Table?
    This is where I might have problems. I have a couple of tables which I use as "lookup" tables where I list the possible selections for an input form. I don't link that table to any other one. But if I leave it alone on the Advance Security settings page, then it warns me that the data types aren't the same and that they may not work properly.
  3. Do I really need to establish a link for every table?
  4. Is this the same issue as the Master - Detail limitation that other postings are referring to?
M
 		mrjtdude 5/4/2008

I might have missed a simple concept a while back. If so, then I'm in deep doo doo. Ha!

When setting the Advanced Security Settings, it prompts you to identify the Users Table:OwnerID field and then to relate it to the MainTable: OwnerID field.
What I have overlooked, is that you can select "Current table" at the top of the form. My questions are:

  1. Do you have to select EVERY table in your database and establish the appropriate linkage?
  2. Does this mean that every single table (eg. Main Table) needs to have a field that links back to the Users Table?
    This is where I might have problems. I have a couple of tables which I use as "lookup" tables where I list the possible selections for an input form. I don't link that table to any other one. But if I leave it alone on the Advance Security settings page, then it warns me that the data types aren't the same and that they may not work properly.
  3. Do I really need to establish a link for every table?
  4. Is this the same issue as the Master - Detail limitation that other postings are referring to?


"I can feel your paaain" - aka slick william aka teflon dilly
thanks for posting this question because it just fixed a problem of ownership i had.
i have 3 tables that all need to be apart of the same 'record book' so to speak....

in other words one record from multiple tables belonging to one customer when they logon...users can see and edit their own data is set for that...
users table owner id field - i kept the same through all tables - the other is just your blank fields you have marked in your key columns...hope that gives you an idea as iam stilll new to the whole game of mysql and phprunner...
regards,

mrjtdude
J
 		Jane 5/5/2008

Bill,
users can see and edit their own records only security method is used for those tables which you want to restrict user access for.

Use users can see and edit other users data option for lookup tables.