UFN_SECURITY_APPUSER_GRANTED_FORM_IN_NONSITEROLE
Returns true if a user has access to a form in a role with no site security.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN | |
| @DATAFORMINSTANCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_SECURITY_APPUSER_GRANTED_FORM_IN_NONSITEROLE]
(
@APPUSERID uniqueidentifier,
@DATAFORMINSTANCEID uniqueidentifier
)
returns bit as
/*
Returns true if the given user has permissions to the given task
in a role whose site security is set to all records.
*/
begin
if exists
(
select
1
from
dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM as SECURITYVIEW
where
SECURITYVIEW.APPUSERID = @APPUSERID and
SECURITYVIEW.DATAFORMINSTANCECATALOGID = @DATAFORMINSTANCEID and
SECURITYVIEW.GRANTORDENY = 1 and
SECURITYVIEW.SITESECURITYMODE = 0
)
return 1;
return 0;
end