5-WayUserPermissionsComparison.sql (1.7 KB)
Run this SQL query to find differences in permissions between 5 different Sierra logins. One login name is specified in each of the LEFT OUTER JOINs. If you jneed to compare fewer users, the easiest way to handle that is to name one of the logins multiple times in the LOJs. To compare more than 5 users, just add more code, following the existing pattern.
This query deliberately suppresses rows where all logins share a permission or where no logins share a permission. Following a version upgrade in which new permissions are introduced, the suppression will hide the availability of those new features, but you can tweak this behavior by commenting out or deleting portions of the WHERE clause.