select systemuser.FullName as Usuario, PO.ObjectId as 'GUID Entidad', E.Name as 'Tipo de entidad' from PrincipalObjectAccess as PO
inner join MetadataSchema.Entity E on PO.ObjectTypeCode = E.ObjectTypeCode
inner join SystemUser on PO.PrincipalId = systemuser.SystemUserId
where AccessRightsMask <> 0
and Name <> 'ActivityPointer' and Name <> 'SystemUser' and Name <> 'UserSettings'
and PrincipalTypeCode = 8 and systemuser.FullName = @Usuario
order by Usuario, [Tipo de entidad]
No hay comentarios:
Publicar un comentario