The Tech-Fi

The technology Fiction logo

🔒 Enhance Data Security with Salesforce SOQL: Utilizing “WITH SECURITY ENFORCED” and “strip.inaccessible” 🛡️

If you’re a Salesforce Admin or Salesforce developer, this data security tip is a must for you…



Introduced in Salesforce API version 41.0, the “WITH SECURITY ENFORCED” clause in SOQL allows developers to enforce the current user’s field- and object-level permissions on the queried data. This ensures that only records accessible to the user, based on their profile settings and sharing rules, are retrieved.


Consider the following example:


In this query, the “WITH SECURITY ENFORCED” clause ensures that only accounts accessible to the current user are returned, adhering to the organization’s security model.

Leveraging “strip.inaccessible”

What is “strip.inaccessible”?

“strip.inaccessible” is a method introduced in Apex, Salesforce’s programming language, that complements “WITH SECURITY ENFORCED.” It allows developers to remove records from a list that the current user doesn’t have access to, providing an additional layer of data security.

How to Use “strip.inaccessible”

Here’s an example illustrating the use of “strip.inaccessible” in Apex:

Ex : List<Account> accounts = [SELECT Id, Name FROM Account];
List<Account> accessibleAccounts = Security.stripInaccessible(AccessType.READABLE, accounts);

In this code snippet, the “strip.inaccessible” method filters out accounts that the current user doesn’t have read access to, ensuring that only accessible records are retained.

Advantages of using “WITH SECURITY ENFORCED” and “strip.inaccessible”

1. Fine-grained Data Security:** Both features contribute to a fine-grained approach to data security, allowing organizations to implement strict controls on who can access what data.

2. Consistent Enforcement: With “WITH SECURITY ENFORCED” and “strip.inaccessible,” data security rules are consistently applied across queries and code, reducing the risk of inadvertent data exposure.

3. Improved Compliance:

For organizations operating in regulated industries, these features offer enhanced compliance by ensuring that only authorized users access sensitive information.

4. Developer Flexibility: Developers have the flexibility to choose the right approach based on specific use cases. Whether working directly with SOQL queries or within Apex code, these tools provide adaptable solutions.

Best Practices for Implementation

1. Understand User Profiles: Familiarize yourself with the user profiles and their associated field-level security settings to ensure accurate enforcement.

2. Regularly Review Code: Regularly review and update your code to incorporate the latest security features and adhere to best practices.

3. Educate Developers:

Ensure that your development team is well-versed in the usage of “WITH SECURITY ENFORCED” and “strip.inaccessible” to maximize the benefits of these features.

4. Test Thoroughly:

Conduct thorough testing to verify that data security is consistently enforced across various user profiles and scenarios.


In a world where data breaches are a constant threat, Salesforce’s commitment to data security shines through features like “WITH SECURITY ENFORCED” and “strip.inaccessible.” By implementing these tools effectively, organizations can ensure that sensitive data remains in the hands of those who need it, striking a balance between accessibility and security.


Frequently Asked Questions (FAQs)

1. Can “WITH SECURITY ENFORCED” be used with any SOQL query?

  • Yes, “WITH SECURITY ENFORCED” can be applied to any SOQL query to enforce the current user’s permissions.

2. Does “strip.inaccessible” impact query performance?

  • While “strip.inaccessible” adds a negligible overhead, its benefits in enhancing data security often outweigh any minimal performance impact.

3. How does “WITH SECURITY ENFORCED” handle complex data models with multiple relationships?

  • “WITH SECURITY ENFORCED” navigates complex data models seamlessly, enforcing permissions across various object relationships.

4. Are these features available in all Salesforce editions?

  • Yes, “WITH SECURITY ENFORCED” and “strip.inaccessible” are available in all editions of Salesforce.

5. Can these features be disabled for specific queries or scenarios?

  • While generally applied for enhanced security, developers have the flexibility to choose when and where to implement these features based on specific use cases.

By leveraging these features effectively, organizations can fortify their defenses against potential data breaches, ensuring a robust and responsive system that balances accessibility with stringent security measures.

1 thought on “🔒 Enhance Data Security with Salesforce SOQL: Utilizing “WITH SECURITY ENFORCED” and “strip.inaccessible” 🛡️”

Leave a Comment