Permisos Usuarios

SELECT permission_name as Permiso, class_desc as Tipo_Objeto,COALESCE(OBJECT_SCHEMA_NAME(major_id),'.') as Esquema,

COALESCE(OBJECT_NAME(major_id),'.') as Objeto, USER_NAME(grantee_principal_id) as Usuario, USER_NAME(grantor_principal_id) Otorgador

FROM sys.database_permissions JOIN sys.database_principals ON principal_id=grantee_principal_id

WHERE COALESCE(OBJECT_SCHEMA_NAME(major_id),'.')='Esquema_Name'