Sql Report - Access Permissions for user
Can someone offer support in generating a sql report based to find out the following information
UserID
Full Name
Permissions
i can run two queries
1:
select AaaUser.USER_ID,AaaUser.FIRST_NAME,AaaLogin.NAME
from AaaUser
Inner join AaaLogin
on AaaUser.USER_ID=AaaLogin.USER_ID
2
SELECT
au.FIRST_NAME 'Technician',
ar1.NAME 'Role'
FROM HelpdeskCrew hdc
LEFT JOIN SDUser sd
ON hdc.TECHNICIANID = sd.USERID
LEFT JOIN AaaLogin al
ON sd.USERID = al.user_id
LEFT JOIN AaaUser au
ON al.user_id = au.user_id
LEFT JOIN AaaAccount aa
ON al.LOGIN_ID = aa.LOGIN_ID
LEFT JOIN AaaAuthorizedRole aar
ON aa.ACCOUNT_ID = aar.ACCOUNT_ID
LEFT JOIN AaaRole ar
ON aar.ROLE_ID = ar.ROLE_ID
LEFT JOIN aaaimpliedrole air
ON ar.role_id = air.role_id
LEFT JOIN aaarole ar1
ON ar1.ROLE_ID = air.IMPLIEDROLE_ID
order by 1
Can these be combine to provide
a result of:
UserID
Full Name
Permissions