To Check the permissions of the service accounts
Select P.name As Principal, class_desc As PermissionLevel, permission_name As PermissionGranted, ObjectName = Case class When 0 Then DB_NAME() When 1 Then OBJECT_SCHEMA_NAME(major_id) + N'.' + OBJECT_NAME(major_id) End From sys.database_permissions As DP Inner Join sys.database_principals As P On P.principal_id = DP.grantee_principal_id Where permission_name In ('insert', 'update', 'delete', 'control', 'alter') And state = 'G'; -- Grant