Kullanıcı bazında yetki detayları

SELECT tDist.Code AS DistribütorKodu,
tDist.Name AS DistribütörAdı,
tUser.IDUser AS KullaniciID,
tUser.UserName AS KullaniciAdi,
tUser.Name AS Ad,
tUser.CreateDate AS YaratilmaTarihi,
CASE
WHEN tUser.Disabled = 0 THEN 'Aktif'
WHEN tUser.Disabled = 1 THEN 'İptal'
ELSE 'Bilinmeyen'
END AS AktifPasifBilgisi,
ISNULL(tAuthGroup.Name, 'Yok') AS YetkiGrubu,
--ISNULL(tAuth.Name, 'Yok') AS YetkiAdi,
--ISNULL(CAST(tAuth.Code AS NVARCHAR), 'Yok') AS YetkiKodu,
--ISNULL(CAST(tAuth.IsAdmin AS NVARCHAR), 'Yok') AS AdminYetkisi,
--ISNULL(CAST(tAuth.MaskIData AS NVARCHAR), 'Yok') AS IslemYetkisi,
--ISNULL(tRoleAuthSub.Code, 'Yok') AS AltYetkiAdi,
ISNULL(CAST(tRoleAuth.Code AS NVARCHAR), 'Yok') AS AltYetkiKodu,
ISNULL(CAST(tRoleAuthSub.SubCode AS NVARCHAR), 'Yok') AS AltYetkiKoduDetay,
CASE
WHEN tUser.UserPDA = 1 THEN 'Mobil Kullanıcısı'
ELSE 'Mobil Kullanıcısı Değil'
END AS MobilKullaniciBilgisi,
CASE
WHEN tUser.UserClient = 1 THEN 'Ofis Kullanıcısı'
ELSE 'Ofis Kullanıcısı Değil'
END AS OfisKullaniciBilgisi,
CASE
WHEN tUser.ScopeFlags = 1 THEN 'Normal Bayi'
WHEN tUser.ScopeFlags = 2 THEN 'Direk Dağıtım'
ELSE 'Bilinmeyen Kapsam'
END AS BayiKapsamBilgisi,
CASE
WHEN tUser.UserAdmin = 1 THEN 'Yönetici'
ELSE 'Yönetici Değil'
END AS YoneticiBilgisi
FROM
tUser
LEFT JOIN tRoleAuth ON tUser.IDRole = tRoleAuth.IDRole and tUSer.IDRoleDist= tRoleAuth.IDDist
LEFT JOIN tRoleAuthSub ON tRoleAuthSub.IDRole = tUser.IDRole and tUSer.IDRoleDist= tRoleAuthSub.IDDist and tRoleAuth.Code=tRoleAuthSub.Code
--LEFT JOIN tAuthSub ON tAuthSub.Code=tRoleAuthSub.Code and tRoleAuthSub.SubCode=tAuthSub.SubCode
LEFT JOIN tAuth ON tRoleAuth.Code = tAuth.Code
LEFT JOIN tAuthGroup ON tAuth.IDAuthGroup = tAuthGroup.IDAuthGroup
--LEFT JOIN tRoleAuthSub ON tRoleAuthSub.IDRole = tRoleAuth.IDRole
LEFT JOIN tDist ON tUser.IDDist = tDist.IDDist
--WHERE
-- IDUser = 3020 and tUser.IDDist=0 and tAuthGroup.Name='uSER'
ORDER BY
tDist.Code DESC;