This topic is locked

Restrict record access in Ver 5.2

11/15/2009 6:26:25 PM
ASPRunnerPro General questions
J
JimSmiley author

I need to create a Purchase Order form that the Vendor can edit. How would I restrict access to a record based on the Vendor name/number that the PO is placed with?

Sergey Kornilov admin 11/16/2009

I recommend to take a look at Advanced Security settings. You can choose advanced security mode 'Users can see and edit their own data only' for this purpose.

J
JimSmiley author 11/16/2009



I recommend to take a look at Advanced Security settings. You can choose advanced security mode 'Users can see and edit their own data only' for this purpose.


Thanks for the quick response. Here is my problem:
For this project there is only 1 "User", the person placing the Purchase Order. The orders are to be placed with one of several "Vendors". The "Vendor" will then edit/update the PO to include additional data (Est ship date, Shipping Doc #, etc). I only want the "Vendor" to view PO's directed to them, not every PO in the system. What I'm looking for is an event that will sort PO's by "Vendor" name and only show PO's related to their company.
Is this possible?

Sergey Kornilov admin 11/16/2009

If you only have one user how do you tell one vendor from another? There must be a separate record in login table for each vendor to make this work.

C
clig 11/18/2009



Thanks for the quick response. Here is my problem:
For this project there is only 1 "User", the person placing the Purchase Order. The orders are to be placed with one of several "Vendors". The "Vendor" will then edit/update the PO to include additional data (Est ship date, Shipping Doc #, etc). I only want the "Vendor" to view PO's directed to them, not every PO in the system. What I'm looking for is an event that will sort PO's by "Vendor" name and only show PO's related to their company.
Is this possible?


your security of those pages within asprunner would then would be based on vendor name for edit / read purposes not the login of the user - kinda like a roles based security model...