We have a custom plugin, where we force our users to use each time they want to create a document. There is a link to ‘Add document’ which normally brings up a list of available templates. But some users are receiving an error message as soon as the ‘Add document’ link is clicked. The error message is:
System.Data.SqlClient.SqlException: You don't have the required permission. You need at least the '{0}' permission on the '{1}'.params[{View}, {Template}]
Can you confirm what the issue might be?
Hello Lewis,
Please share a complete error message with us.
If possible please share the screenshot of the error message.
Thanks & Regards
Swapnil Tapadia
Please see if the person has the modify permission in security tab.
As Aakanksha shows in above image, please check the template level security and make sure that user who is accessing that template must be there in security.
It might be possiblity that, user may not have view/edit permissions or template may not have view permissions for everyone.
Hi Lewis,
Aakanksha and Swapnil are correct. Security is indeed the issue here.
The problem is that the user logged on does not have 'view' permissions on the template.
So which template?
When you click the 'Add document' link, normally a list of templates in a drop down is displayed. The list contains templates which the user has been assigned 'can use' permissions, and is ordered alphabetically.
The specific template concerned is the one at the top of the list, which explains why not all users are affected.
So the problem is that the template at the top of the list has been assigned 'can use' but not 'view' permissions. Workaround therefore is to assign the 'view' permission to the template accordingly.
It seems that maybe this custom plugin is not handling this scenario well, and I will feed this info back to the solutions center to address when you next upgrade.
And welcome to the forum :)
Regards,
RichT
Answer Verified By: Lewis Caddock