UFN_APPUSER_ISSYSADMIN
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN |
Definition
Copy
create function BBDW.[UFN_APPUSER_ISSYSADMIN]
(
@APPUSERID uniqueidentifier
)
returns bit
as
begin
declare @isSysAdmin as bit
set @isSysAdmin = 0
select
@isSysAdmin = a.[APPUSERISSYSADMIN]
from
BBDW.[DIM_APPUSER] a
where
a.[APPUSERSYSTEMID] = @APPUSERID;
return @isSysAdmin
end