Třídová akce

Kód:

2

Tělo:

SELECT A.ID, A.Code, A.Name, A.LicenseID
FROM RoleApps A
WHERE EXISTS
  ( SELECT B.ID
        FROM RoleAppProfiles B
	JOIN RoleAppProfileRoles C on C.Parent_ID = B.ID 
	JOIN SecurityUserRoleLinks SURL ON SURL.Role_ID = C.Role_ID
        JOIN SecurityUserAllowedApps SUAA ON SUAA.User_ID = :UserID and SUAA.AppID = A.LicenseID
	WHERE B.App_ID = A.ID AND SURL.User_ID = :UserID
  )
  

Generated by ABRA Software a.s. 27.10.2021 16:34:11