SAP Business One query that shows users, authorizations, and licenses

 SELECT T0.USERID AS 'User ID', T0.USER_CODE AS 'User Code', T1.LicType AS 'License Type', T2.AuthName AS 'Authorization Name'

FROM OUSR T0 LEFT JOIN USR7 T1 ON T0.USERID = T1.USERID LEFT JOIN UACR T2 ON T1.AuthorID = T2.AuthID ORDER BY T0.USERID, T2.AuthName