UFN_PROSPECTRESEARCHREQUEST_USERHASSITEACCESS

Validates that an application user has access to a prospect research request based on site permissions.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@PROSPECTRESEARCHREQUESTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_PROSPECTRESEARCHREQUEST_USERHASSITEACCESS
            (
                @PROSPECTRESEARCHREQUESTID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier,
                @SECURITYFEATUREID uniqueidentifier = null,
                @SECURITYFEATURETYPE tinyint = null
            )
            returns bit
            as
            begin

                /* If custom code doesn't want to pass in the security stuff, don't do security */
                if @SECURITYFEATUREID is null or @SECURITYFEATURETYPE is null
                    return 1;

                if exists    (
                                select PRRS.SITEID 
                                from dbo.PROSPECTRESEARCHREQUEST PRR
                                left join dbo.PROSPECTRESEARCHREQUESTSITE PRRS on PRRS.PROSPECTRESEARCHREQUESTID = PRR.ID 
                                inner join dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) [S]
                                    on ([S].SITEID = PRRS.SITEID) or ([S].SITEID is null and PRRS.SITEID is null)
                                where PRR.ID = @PROSPECTRESEARCHREQUESTID
                            )
                    return 1;

                return 0;
            end