Mastering Salesforce Metadata Auditing With SOQL: Practical Examples and Best Practices

When did you last audit your Salesforce permissions?

If you can’t answer immediately, you’re not alone. Most Salesforce orgs have permission gaps lurking in their configuration. Additionally, these gaps often go unnoticed until an audit or breach exposes them.
Metadata auditing in Salesforce is essential for security, compliance, and governance. Furthermore, it helps you understand who can access what data. Without thorough auditing, unauthorized access can go unnoticed. Consequently, your organization faces increased security and compliance risks.

Why Metadata Auditing Is Critical

Salesforce environments are dynamic. Teams make frequent schema and permission changes. Therefore, administrators need visibility into these modifications. Otherwise, problems can accumulate silently.

Auditing metadata lets administrators identify several critical issues:

  • Overly permissive profiles that grant excessive access
  • Unused fields cluttering objects and confusing users
  • Changes that could impact security or operations
  • Permission combinations that violate security policies

Moreover, regular auditing helps maintain visibility. It also enforces organizational policies effectively. Additionally, it provides documentation for compliance requirements.

But here’s what most admins don’t realize. Manual auditing through the UI is time-consuming. Furthermore, it’s prone to human error. That’s where SOQL-based metadata auditing comes in.

Using SOQL to Audit Your Metadata

SOQL provides a programmatic way to query metadata objects. These include EntityDefinition, FieldDefinition, and permission-related objects. Consequently, this enables ongoing, automated auditing beyond manual inspection.

The key metadata objects you’ll work with include:

  • EntityDefinition: Metadata about all objects
  • FieldDefinition: Detailed information about fields
  • ObjectPermissions: Object-level CRUD permissions
  • FieldPermissions: Field-level security settings

Querying Objects with EntityDefinition

To list all custom objects in your org, use this query. It returns downloadable details about every custom object available.

SELECT QualifiedApiName, Label, KeyPrefix, IsQueryable, IsApexTriggerable
FROM EntityDefinition
WHERE QualifiedApiName LIKE '%__c'
ORDER BY QualifiedApiName

This query filters for custom objects specifically. Additionally, it shows key properties for each object. Therefore, it helps assess what custom data your org stores.

The results tell you several important things:

  • Whether objects can be queried via SOQL
  • If Apex triggers can be created
  • The three-character ID prefix for identification

Auditing Fields with FieldDefinition

To see field details, query the FieldDefinition object. This shows attributes like data type and calculated status.

SELECT EntityDefinition.QualifiedApiName, QualifiedApiName, Label, DataType, IsCalculated
FROM FieldDefinition
WHERE EntityDefinition.QualifiedApiName = 'Account'
ORDER BY QualifiedApiName

This reveals the attributes of each Account field. Moreover, it helps audit field-level access and constraints. You can also identify formula fields that might impact performance.

To find only custom fields, add this filter:

AND QualifiedApiName LIKE '%__c'

This refinement focuses your audit on customizations. Additionally, it excludes standard Salesforce fields from results.

Auditing User Permissions

Understanding which users can access what is crucial. Therefore, use queries over ObjectPermissions and FieldPermissions. Additionally, link them through PermissionSetAssignment to specific users.

Checking Object-Level Permissions

This query shows which profiles can access Account records:

SELECT Parent.Profile.Name, Parent.Label, SObjectType, PermissionsRead, PermissionsEdit
FROM ObjectPermissions
WHERE SObjectType = 'Account'

This reveals which permission sets grant Account access. Furthermore, it shows the specific CRUD operations allowed. Consequently, you can identify overly permissive configurations quickly.

Auditing Field-Level Security

Field-level security protects sensitive data. Therefore, understanding field access is critical.

SELECT Parent.Profile.Name, Parent.Label, SObjectType, Field, PermissionsRead, PermissionsEdit
FROM FieldPermissions
WHERE SObjectType = 'Contact' AND Field = 'Contact.Email'

This shows exactly who can read or edit the Email field. Additionally, you can modify the query for any field. Simply change the object and field names as needed.

Finding Users with Specific Permissions

To identify actual users with specific permissions, use this approach:

SELECT Assignee.Name, Assignee.Username, PermissionSet.Name, PermissionSet.Profile.Name
FROM PermissionSetAssignment
WHERE PermissionSetId IN (
  SELECT ParentId FROM FieldPermissions
  WHERE Field = 'Account.Rating' AND PermissionsEdit = true
)

This query combines permission configuration with user assignments. Consequently, you get a complete picture of actual user access. Moreover, it works for both custom and standard fields.

Real-World Use Case: Detecting Excessive Permissions

Let’s say you need to find excessive edit permissions. Specifically, you want to identify non-admin profiles with Contact edit access.

SELECT Parent.Profile.Name, Field, PermissionsEdit
FROM FieldPermissions
WHERE SObjectType = 'Contact'
  AND PermissionsEdit = true
  AND Parent.Profile.Name NOT LIKE '%Admin%'

This query identifies potential security risks immediately. Additionally, it helps you review whether edit access aligns with roles. Therefore, you can enforce the principle of least privilege effectively.

Practical Benefits of SOQL-Based Metadata Auditing

Automated SOQL queries integrate into monitoring tools easily. Moreover, they fit naturally into continuous deployment pipelines. Consequently, you can detect insecure changes immediately.

Organizations can generate compliance reports regularly. Therefore, they prove security posture during audits. Additionally, automated auditing reduces manual effort significantly.

Key benefits include:

  • Faster security reviews compared to manual clicking
  • Automated compliance documentation generation
  • Early detection of configuration drift
  • Reduced risk of security breaches
  • Better visibility into permission structures

Best Practices for Metadata Auditing

Automate Regular Audits

Manual audits are time-consuming and often deprioritized. Instead, build automated solutions using Apex scheduled classes. Additionally, consider using Flow scheduled paths for simpler scenarios.

Create scheduled jobs that execute these queries regularly. Moreover, compare results to baseline expectations automatically. Furthermore, send alerts when anomalies are detected.

Document Your Baseline

Before detecting drift, establish what normal looks like. Therefore, run comprehensive queries when your org is configured properly. Additionally, document these results as your security baseline.

Store baseline configurations in version control. Moreover, update your documentation when making approved changes. This keeps your baseline current and relevant.

Combine Queries for Deeper Insights

Individual queries provide specific answers. However, combining multiple queries yields deeper insights. Therefore, correlate object metadata with permission data regularly.

Join field metadata with permission settings. Additionally, track when new objects receive permission configurations. This reveals patterns in your security model.

Respect Query Limits

Metadata objects have specific query limits. EntityDefinition and FieldDefinition are virtual objects. Therefore, they don’t support all SOQL features equally.

Remember that these queries count against API limits. Additionally, design your automation thoughtfully to avoid hitting limits. Furthermore, test queries thoroughly before deploying automation.

Advanced Techniques

Using Tooling API for Enhanced Access

Standard SOQL provides extensive metadata access. However, Tooling API offers additional capabilities for specific use cases. Additionally, some fields are only available through Tooling API.

The Metadata field on FieldDefinition requires Tooling API. Therefore, use HTTP callouts to your own org. Alternatively, enable ‘Use Tooling API’ in Developer Console.

Building Custom Audit Dashboards

Create custom objects to store audit results over time. Then, build dashboards that visualize trends and patterns. Additionally, track permission set assignments to identify changes.

Chart the growth of custom fields per object. Moreover, visualize permission distribution across profiles. This helps maintain balanced access control.

Integration with CI/CD Pipelines

Integrate metadata auditing into deployment pipelines. Therefore, catch configuration issues before they reach production. Additionally, automate security checks during development.

Run audit queries as part of your deployment process. Moreover, fail deployments that violate security policies. This prevents security regressions automatically.

Conclusion

Salesforce metadata auditing with SOQL is a powerful governance technique. Moreover, it maintains control over your org’s configuration and security. Additionally, combining SOQL queries with automation enhances visibility significantly.

These techniques reduce risks and support compliance requirements effectively. Furthermore, mastering these queries equips administrators to run secure deployments. Therefore, start implementing these queries in your org today.

Begin with simple queries to familiarize yourself with metadata objects. Then, gradually build more sophisticated audit processes over time. Additionally, remember that effective auditing is ongoing, not one-time.

Ready to take your Salesforce governance to the next level? Start by running the queries in this article. Moreover, schedule time each week for metadata auditing activities.c

Read More

Apex in 2026: What Salesforce Developers Need to Know

Share this article...

As Managing Partner and CTO at codeSTREETS, I help global businesses scale through robust Salesforce architecture and custom software solutions. With 10+ years of experience in enterprise transformation, I lead teams to deliver results-driven, future-ready digital platforms. My expertise spans cloud architecture, product innovation, and mentorship, earning recognition as a speaker and community leader. Let’s connect if you’re seeking tailored solutions, seamless implementation, or strategic partnerships to accelerate your business growth.

Leave a Reply

Your email address will not be published. Required fields are marked *