Třídová akce

Kód:

2

Tělo:

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

union

select SU.ID from 
SecurityRoleGroupLinks SRGL 
join SecurityUserRoleLinks SURL on SURL.Role_ID = SRGL.Role_ID
join SecurityUsers SU on SU.ID = SURL.User_ID
WHERE SRGL.Group_ID = :Group_ID
and SU.Locked = 'N'

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