UFN_CONSTIT_SECURITY_APPUSER_FORM_RINGFENCES

    create function dbo.UFN_CONSTIT_SECURITY_APPUSER_FORM_RINGFENCES
    (
    @APPUSERID uniqueidentifier,
    @DATFORMINSTANCEID uniqueidentifier
    )
    returns table as

    return 

        (
        select DISTINCT
        SR.CONSTIT_SECURITY_ATTRIBUTEID AS RINGFENCEID

        from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM as SV
        left outer join dbo.SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE
        AS SR ON SV.SYSTEMROLEID=SR.ID

        WHERE 

        SV.GRANTORDENY=1
        AND SV.DATAFORMINSTANCECATALOGID=@DATFORMINSTANCEID
        AND SV.APPUSERID=@APPUSERID 

        )