Activity Forums Salesforce® Discussions How can we find if a particular user has edit permission on a specific Sobject in salesforce?

  • Kumar

    Member
    February 22, 2017 at 10:04 AM

    Hi Sushant,

    If you have a particular user id, you can query on the PermissionSetAssignment object to get the id of all users who have a specific level of access on that Sobject.

    For example, this query gives you all the users who have 'view all' and 'modify all' permissions on Account.

    SELECT Assignee.Id, Assignee.Name FROM PermissionSetAssignment WHERE PermissionSetId IN (SELECT ParentId FROM ObjectPermissions WHERE SObjectType = 'Account' AND PermissionsViewAllRecords = true AND PermissionsModifyAllRecords = true)

    • This reply was modified 8 years, 9 months ago by  Kumar.

Log In to reply.

Popular Salesforce Blogs

The Intelligent Commerce Stack: How Salesforce is Powering the Next Generation of Online Retail

Blog in

Online retail faces growing challenges: managing complex operations, integrating multiple sales channels, and delivering personalized, consistent experiences across B2C and B2B segments. Traditional commerce systems…

Popular Salesforce Videos