How to query user permissions and the source of that permission in Veeva CRM?
The following SOQL query is very useful in determining user permission and the source of those permissions:
SELECT Field,Parent.Label,Parent.Profile.Name,PermissionsEdit,PermissionsRead,SobjectType FROM FieldPermissions where ParentId in (SELECT PermissionSetId
WHERE Assignee.ID = 'user id') and Field In('<object api name>.<field api name>')
For example, to query the Call_Date_vod__c field on the Call object, the query and the result is displayed as shown in Workbench:
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.