Developer console Profile object query not executed

Question

I have query that will execute the Profile object Query in Developer console.

My query :

SELECT Id,Name,UserType,objectPermissions,userPermissions from Profile

Error:

SELECT Id,Name,UserType,objectPermissions,userPermissions

ERROR at Row:1:Column:25 No such column 'objectPermissions' on entity 'Profile'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.

I need to see the data UserType,objectPermissions from Profile Object.

Please some help me,

Best Regards, Ramesh

Answer 1

ObjectPermissions is a distinct object in its own right, not fields on the Profile object. You need to do a query directly on that object.

select SobjectType, PermissionsCreate, PermissionsDelete, PermissionsEdit, PermissionsModifyAllRecords, PermissionsRead, PermissionsViewAllRecords, 
from ObjectPermissions