Question:

How to query user permissions and the source of that permission in Veeva CRM?

Answer:

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
FROM PermissionSetAssignment
WHERE Assignee.ID = 'user id') and Field In('<object api name>.<field api name>')

Example:

To query the  Call_Date_vod__c field on the Call object, the query and the result is displayed as shown in Workbench:

Related Documentation:

N/A  

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.