fnRoleObjectPrivsByGuid

            CREATE  FUNCTION [dbo].[fnRoleObjectPrivsByGuid]
            (
            @ObjectGuid uniqueidentifier
            )

            RETURNS @ObjectPrivs TABLE (
            ClientRolesID int primary key,
            canview bit,
            canedit bit,
            canadd bit,
            candelete bit,
            cansecure bit
            )
            AS
            BEGIN

            insert into @ObjectPrivs
            SELECT DISTINCT ClientRolesID,canview,canedit,canadd,candelete,cansecure
            FROM RoleObjectPrivs
            WHERE ObjectGuid=@ObjectGuid
            RETURN
            END