Třídová akce

Kód:

1

Tělo:

select SU.ID from
SecurityUserRoleLinks SURL
join SYS$SecurityRoles2 SSR2 on SSR2.ID = SURL.Role_ID
join SecurityUsers SU on SU.ID = SURL.User_ID
where SSR2.Superior_ID = :Role_ID
and SU.Locked = 'N'

union

select SU.ID from
SecurityUserRoleLinks SURL
join SecurityUsers SU on SU.ID = SURL.User_ID
where SURL.Role_ID = :Role_ID
and SU.Locked = 'N'

Generated by ABRA Software a.s. 27.10.2021 16:35:16