function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
St2018St2018 

How can I get a list or matrix of field level security set on every field for all profiles on a particular object?

@Amit Kumar Giri@Amit Kumar Giri
For all profile , for a object at once i think not possible (in a better way) or may be i am not able to think of. But certainly for one profile for one object at a time yes you can see the result by running a SOQL query like below .
>> Lets say for Opportunity and for System admin profile. 
SELECT Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE SObjectType = 'Opportunity' AND parentid in (select id from permissionset where PermissionSet.Profile.Name = 'System Administrator')

User-added image
For multiple prifile,you can put Or condition in the query but it will start showing result for the 2nd profile right after above result so it will be messy to identify.
like this  
SELECT Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE SObjectType = 'Opportunity' AND parentid in (select id from permissionset where PermissionSet.Profile.Name = 'System Administrator' OR PermissionSet.Profile.Name = 'Standard User')
if u will run above query result will start after row 28 for standard user profile.
 
Meenu MathewMeenu Mathew
Hi Stephanie,

Please refer the following link
https://success.salesforce.com/answers?id=9063A000000DkZNQA0
https://success.salesforce.com/answers?id=90630000000gnuGAAQ

Thanks