You need to sign in to do that
Don't have an account?
Rafal Galazkiewicz 4
Insufficient Privileges
I'm following work.com workbook but having it prinstalled from Salesforce 1 for admin guide so some parts need some modifications still. I have encountered this tricky issue.
Schema is such:
Warehouse (Master) - (detail) Merchandies (Master) - (detail) Line Item (detail) - (Master) Invoice
No roles in place yet
OWD:
Invoice Private
Line Item Controlled by Parent
Merchandise Controlled by Parent
Warehouse Public Read Only
Profile:
Merchandise Read
Warehouse Read
Permission set:
Invoices Read, Create, Edit, Delete
Line Items Read, Create, Edit, Delete
Merchandise Read
Warehouses Read
I can create Invoice record. Then on Line Item related list I click on New. Input webform opens. Invoice field is prefilled as open from related list and then I browse any Merchandise (owned by other user) and click save and I got this error:
"Insufficient Privileges
You do not have the level of access necessary to perform the operation you requested. Please contact the owner of the record or your administrator if access is necessary."
Why is that? When I change OWD for Merchandise to Public Read/Write it lets me save Line Item record but why? Based on my definition order of relationship is such that primary is between Invoice and Line Item.
I'm lost a bit here ir it's so simple that I just don't see it.
Please help.
Schema is such:
Warehouse (Master) - (detail) Merchandies (Master) - (detail) Line Item (detail) - (Master) Invoice
No roles in place yet
OWD:
Invoice Private
Line Item Controlled by Parent
Merchandise Controlled by Parent
Warehouse Public Read Only
Profile:
Merchandise Read
Warehouse Read
Permission set:
Invoices Read, Create, Edit, Delete
Line Items Read, Create, Edit, Delete
Merchandise Read
Warehouses Read
I can create Invoice record. Then on Line Item related list I click on New. Input webform opens. Invoice field is prefilled as open from related list and then I browse any Merchandise (owned by other user) and click save and I got this error:
"Insufficient Privileges
You do not have the level of access necessary to perform the operation you requested. Please contact the owner of the record or your administrator if access is necessary."
Why is that? When I change OWD for Merchandise to Public Read/Write it lets me save Line Item record but why? Based on my definition order of relationship is such that primary is between Invoice and Line Item.
I'm lost a bit here ir it's so simple that I just don't see it.
Please help.
Hint came from this article -
https://help.salesforce.com/HTViewHelpDoc?id=relationships_manytomany.htm&language=en_US
"Select a Sharing Setting option. For master-detail relationship fields, the Sharing Setting attribute determines the sharing access that users must have to a master record in order to create, edit, or delete its associated detail records."
So I have changed that on Merchandise field master-detail
FROM
Read/Write: Allows users with at least Read/Write access to the Master record to create, edit, or delete related Detail records.
TO
Read Only: Allows users with at least Read access to the Master record to create, edit, or delete related Detail records.
And it works!
All Answers
Hint came from this article -
https://help.salesforce.com/HTViewHelpDoc?id=relationships_manytomany.htm&language=en_US
"Select a Sharing Setting option. For master-detail relationship fields, the Sharing Setting attribute determines the sharing access that users must have to a master record in order to create, edit, or delete its associated detail records."
So I have changed that on Merchandise field master-detail
FROM
Read/Write: Allows users with at least Read/Write access to the Master record to create, edit, or delete related Detail records.
TO
Read Only: Allows users with at least Read access to the Master record to create, edit, or delete related Detail records.
And it works!
Regards,
Ed
That's great that you did benefit from my post. Happy I was able to help you.