2. PHPRunner General questions
  3. user settings
This topic is locked

user settings

 		12/17/2007 9:58:56 AM
PHPRunner General questions
F
 futo author

hello,
i have situation like this:
1.table USERS(fields: company, username, pasword)

2.table INVOICE (fields: user, invoice number, invoice date, invoice value, company)
i want to set up next:

  1. administrator adding all the records
  2. each other user can logg in and see only records which have thei company name in field company)
    what should i doo
    thanks
    p.s. sorry for my english
J
 		Jane 12/18/2007

Hi,
please see my answers:

  1. to restrict user access to INVOICE table use User can see and edit their own records only option on the Advanced security settings dialog on the Security tab and select company as OwnerID field in both tables.
  2. to add admin section create custom view of INVOICE table on the Datasource tables tab for admin, add admin and default accounts on the User group permissions dialog on the Security tab and setup required permissions for these two groups. Check off list, add and edit permissions for custom view of INVOICE table for admin account only.
F
 		futo author 12/25/2007

Hi,

please see my answers:

  1. to restrict user access to INVOICE table use User can see and edit their own records only option on the Advanced security settings dialog on the Security tab and select company as OwnerID field in both tables.
  2. to add admin section create custom view of INVOICE table on the Datasource tables tab for admin, add admin and default accounts on the User group permissions dialog on the Security tab and setup required permissions for these two groups. Check off list, add and edit permissions for custom view of INVOICE table for admin account only.



hello, and happy chrystmass
many thanks for the solution of my problem. its work.

now i have second problem. in the custom view of INVOICE table in column company do not aloving duplicate entry. i can add same company two times
Duplicate entry 'xxxxxx' for key 1
J
 		Jane 12/28/2007

Hi,
you can setup key field as autoincrement field in the database directly or check entered key value in the Before record added event on the Events tab.