UFN_APPUSER_HASALLSITESFORFORM
Returns true if a user has access to all sites for a specified form.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN | |
| @DATAFORMINSTANCECATALOGID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_APPUSER_HASALLSITESFORFORM
(
@APPUSERID uniqueidentifier,
@DATAFORMINSTANCECATALOGID uniqueidentifier
)
returns bit
with execute as caller
as
begin
declare @HASALLSITES bit;
set @HASALLSITES = 0;
if dbo.UFN_APPUSER_ISSYSADMIN(@APPUSERID) = 1
set @HASALLSITES = 1;
else
begin
if exists ( select 1
from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM
where
GRANTORDENY = 1 and
APPUSERID = @APPUSERID and
DATAFORMINSTANCECATALOGID = @DATAFORMINSTANCECATALOGID and
SITESECURITYMODE = 0)
set @HASALLSITES = 1;
end
return @HASALLSITES;
end