Objektová akce

Kód:

8

Tělo:

Select
  User_ID,
  Role_ID,
  'C' As HierarchyStatus
From
  SecurityUserRoleLinks URL
Where
  Role_ID = :OBJID and
  User_ID = :UserID
Union
Select
  URL.User_ID,
  URL.Role_ID,
  'S' As HierarchyStatus
From
  SecurityUserRoleLinks URL
Join
  Sys$SecurityRoles2 SR2
On
  URL.role_id = SR2.superior_id AND
  SR2.id = :OBJID and
  URL.user_id = :UserID and
  'A' = :AcceptSubordinarity

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