UFN_SECURITY_APPUSER_GRANTED_FEATURE_IN_NONRACROLE

create function BBDW.[UFN_SECURITY_APPUSER_GRANTED_FEATURE_IN_NONRACROLE]
(
    @APPUSERID uniqueidentifier,
    @FEATUREID uniqueidentifier,
    @FEATURETYPE tinyint 
)
returns bit as

/*
Returns true if the given user has permissions to the given feature
in a role whose security group is blank

This function is optimized for use from the Blackbaud.AppFx.Security.Catalog.ConstitRecordSecurityService
class which implements the RecordSecurity service for Constituent record security.

As such, it assumes that a check for DENY occurs outside this function
and also assumes that a check for if the user is ISSYSADMIN occurs outside 
this function.  
*/


begin

    if @FEATURETYPE = 2 -- SecurityFeatureType.DataList 
    begin
        return BBDW.[UFN_SECURITY_APPUSER_GRANTED_DATALIST_IN_NONRACROLE](@APPUSERID,@FEATUREID)
    end

    if @FEATURETYPE = 9 -- SecurityFeatureType.SmartQuery  
    begin
        return BBDW.UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_IN_NONRACROLE(@APPUSERID,@FEATUREID)
    end

    if @FEATURETYPE = 10 -- SecurityFeatureType.AdHocQueryView  
    begin
        return BBDW.[UFN_SECURITY_APPUSER_GRANTED_QUERYVIEW_IN_NONRACROLE](@APPUSERID,@FEATUREID)
    end

    return  0;

end