Apex Intermediate Progress | ( Lessons)

Lesson: 06 | Filter SOQL Queries Using WITH SECURITY_ENFORCED

Notes
Video

Notes

WITH SECURITY_ENFORCED applies field- and object-level security checks only to fields and objects referenced in SELECT or FROM SOQL clauses and not clauses like WHERE or ORDER BY. In other words, security is enforced on what the SOQL SELECT query returns, not on all the elements that go into running the query.

If any fields or objects referenced in the SOQL SELECT query using WITH SECURITY_ENFORCED are inaccessible to the user, a System.QueryException is thrown, and no data is returned.

List<Account> act1 = [SELECT Id, (SELECT LastName FROM Contacts), 
   (SELECT Description FROM Opportunities)
   FROM Account WITH SECURITY_ENFORCED]

If field access for either LastName or Description is hidden, this query throws an exception indicating insufficient permissions.

List<Account> act2 = [SELECT Id, parent.Name, parent.Website 
   FROM Account WITH SECURITY_ENFORCED]

If field access for Website is hidden, this query throws an exception indicating insufficient permissions.

List<AggregateResult> agr1 = [SELECT GROUPING(Type) 
   FROM Opportunity WITH SECURITY_ENFORCED 
   GROUP BY Type]

If field access for Type is hidden, this aggregate function query throws an exception indicating insufficient permissions.

You need to login to have access to the quizzes.

Mastered by 4 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

J. Miscellaneous (17 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 06 | Filter SOQL Queries Using WITH SECURITY_ENFORCED

Notes

Apex Intermediate