Home Forums SQL Server 2008 T-SQL (SS2K8) Determine unique combinations of permissions assigned to users RE: Determine unique combinations of permissions assigned to users

  • @dwain.c

    Excellent, that is just what I needed.

    After working with it for a bit this morning, I've determined I need to assign the groups string in a checksum rather than a row_number. Now I don't need to worry about row_number assigments changing erratically when new group combinations are used. The checksum values won't be affected by permissions changes.

    Thanks again.

    Wes

    Wes
    (A solid design is always preferable to a creative workaround)