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