UFN_SITEREQUIREDFORUSERONFEATURE
Returns true if the user is granted a particular feature only in roles that specify a site.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SECURITYFEATUREID | uniqueidentifier | IN | |
| @SECURITYFEATURETYPE | tinyint | IN |
Definition
Copy
create function dbo.[UFN_SITEREQUIREDFORUSERONFEATURE]
(
@CURRENTAPPUSERID uniqueidentifier,
@SECURITYFEATUREID uniqueidentifier,
@SECURITYFEATURETYPE tinyint
)
returns bit
as
begin
if dbo.[UFN_APPUSER_ISSYSADMIN](@CURRENTAPPUSERID) = 1
return 0;
if exists(select top 1 1
from dbo.[UFN_SITESFORUSERONFEATURE](@CURRENTAPPUSERID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) as [SITES]
where [SITES].[SITEID] is null)
return 0;
return 1;
end