Retirement Planning

Query to find Permission sets assigned to Users

DescriptionBelow is the SOQL query we can create using Workbench to capture the Permission Sets associated with a given User or Profile via the Permission Set Assignment object ResolutionQuery: SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE Assignee.Name = ‘JOHN SMITH’ Or retrieve all users associated with a specific PermissionSet like: SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE PermissionSet.Name = ‘Custom […]

Scaling Salesforce Architecture for Compliance-Heavy Enterprises

For enterprises in highly regulated sectors like banking, insurance, healthcare, and government, scaling Salesforce is not just about adding more users or features. It’s about finding the sweet spot between business growth and regulatory compliance. Unlike young startups that can move fast and experiment, compliance-heavy organizations need to tread carefully, making sure every architectural choice […]

Understand & Fixing Salesforce System.LimitException: Too many query rows: 50001

Introduction to Salesforce Governor Limits What are Governor Limits? Salesforce is a multi-tenant environment, which means your code runs on a shared infrastructure. To ensure fair use of resources, Salesforce enforces limits known as governor limits. These rules help prevent any one user or org from monopolizing server resources. Why Do They Exist in Salesforce? […]