SQL - compare 2 user profiles to assigned AUTL

By kimot, 24 December, 2022

SELECT A.AUTL as user1, B.AUTL as user2
FROM (SELECT autl
      FROM QSYS2.AUTHORIZATION_LIST_USER_INFO
      WHERE user_name = 'profile_1')  A
FULL OUTER JOIN (SELECT autl
      FROM QSYS2.AUTHORIZATION_LIST_USER_INFO
      WHERE user_name = 'profile_2')  B 
ON A.AUTL = B.AUTL;