UFN_SECURITY_APPUSER_GRANTED_TASK_IN_NONSITEROLE
Returns true if a user has access to a task in a role with no site security.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN | |
| @TASKID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_SECURITY_APPUSER_GRANTED_TASK_IN_NONSITEROLE]
(
@APPUSERID uniqueidentifier,
@TASKID 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_TASK as SECURITYVIEW
where
SECURITYVIEW.TASKID = @TASKID and
SECURITYVIEW.APPUSERID = @APPUSERID and
SECURITYVIEW.SITESECURITYMODE = 0
)
return 1;
return 0;
end