USP_SECURITY_APPUSER_BYPASSSECURITYFORBUSINESSPROCESS

This procedure determines whether or not an appuser should bypass constituent group security or constituent site security for a given business process.

Parameters

Parameter	Parameter Type	Mode
@APPUSERID	uniqueidentifier	IN
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@BYPASSCONSTITUENTSECURITYGROUPSECURITY	bit	INOUT
@BYPASSCONSTITUENTSITESECURITY	bit	INOUT

Definition

Copy



            create procedure dbo.USP_SECURITY_APPUSER_BYPASSSECURITYFORBUSINESSPROCESS
            (
                @APPUSERID uniqueidentifier,
                @BUSINESSPROCESSCATALOGID uniqueidentifier,
                @BYPASSCONSTITUENTSECURITYGROUPSECURITY bit = null output,
                @BYPASSCONSTITUENTSITESECURITY bit = null output
            )
            as
                set nocount on;

                if @APPUSERID is not null
                begin
                    select @BYPASSCONSTITUENTSECURITYGROUPSECURITY = dbo.UFN_APPUSER_ISSYSADMIN(@APPUSERID);

                    if @BYPASSCONSTITUENTSECURITYGROUPSECURITY = 0 
                        begin
                            select @BYPASSCONSTITUENTSECURITYGROUPSECURITY = dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESS_IN_NONRACROLE(@APPUSERID, @BUSINESSPROCESSCATALOGID);
                            select @BYPASSCONSTITUENTSITESECURITY = dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESS_IN_NONSITEROLE(@APPUSERID, @BUSINESSPROCESSCATALOGID);
                        end
                    else
                        set @BYPASSCONSTITUENTSITESECURITY = 1;
                end
                else
                begin
                    set @BYPASSCONSTITUENTSECURITYGROUPSECURITY = 1;
                    set @BYPASSCONSTITUENTSITESECURITY = 1;
                end