Access *View All* in Administrative Permissions in all profiles through SOQL

Question

I want to access the field value checked/unchecked for all profiles through SOQL.

Answer 1

To access permissions you need to use PermissionSet sobject and ProfileId field on it.

To read more about it, check documentation

Example of soql for your question:

select Profile.Name, PermissionsViewAllData FROM PermissionSet where IsOwnedByProfile = true

Answer 2

You can use below query:

Select Name, PermissionsViewAllUsers, PermissionsViewAllData From Profile