USP_SIMPLEDATALIST_BATCHAVAILABLEUSERS
Returns users who are allowed as owners across all batches.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHAVAILABLEUSERS(@BATCHTEMPLATEID uniqueidentifier = null)
as begin
select APPUSER.ID as VALUE, case when APPUSER.DISPLAYNAME = '' then APPUSER.USERNAME else APPUSER.DISPLAYNAME end as LABEL
from
dbo.APPUSER
join
dbo.UFN_SECURITY_APPUSER_GRANTED_ANY_BATCH() GRANTED_APPUSER on GRANTED_APPUSER.ID = APPUSER.ID
order by LABEL
end