• I just came back to this and found that you cannot use a temp table in a classifier function, meaning I cannot see a way to use sys.xp_logininfo directly to check group membership.

    What you might do is have a proc run periodically to capture the results of sys.xp_logininfo for your groups into a table in master and then refer to that table in your classifier function.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato