2. PHPRunner General questions
  3. Advanced security settings
This topic is locked

Advanced security settings

 		10/3/2005 16:13:46
PHPRunner General questions
B
 bob123 author

I am hoping someone can help me with this, I have just bought PHPRunner and am trying it out.
I have setup the following dbase tables
Customer: Customer Name, Contact, Tel
Service: Customer Name, Service Type, Service No, Service Date
User: Username, Password
I have got everything working well except the Advanced security settings which I can't get on top off.
I want admin to have access all areas and functions and the user to have viewing and print of their own records only. But I just can't seem to get it to work completely correctly I am not setting it up correctly.
At the moment if I ass a new service in the service table it automaticily puts admin in the customer name.
Any help welcome as its got me going a bit nuts
Bobb123

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1943&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
B
 		bob123 author 10/3/2005

Sorry
The above question was poorly worded
What I am trying to do is to have admin able to access all function while the user can only view and print there on records in the service table.
Thanks
Robert
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=6219&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />
Sergey Kornilov admin 10/4/2005

Hi,
you need to set a relationship between User table and Service table.

Here is the article that explains how to do this in great details.
You need to add INTEGER field OwnerID to Service table.

Also you need to add INTEGER field UserID to User table.

Fill in OwnerIDfield and set Advanced security settings for users and tables.
B
 		bob123 author 10/4/2005

Thanks admin for you forum and email reply
I have followed your instrutions to the letter, however I still have the same problem.
When I enter records in the admin screen no matter what customer name I give them they are still entered against the admin user which means when I log on to view as a user I can't view the records. I need a way of entering records in the admin screen that can be view by a user other than admin
I just cant get this to work, and I have followed the example in the help file even copied the table setup.
I will move on, but thanks for the help
Thanks
Bob123
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=6241&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />