User login account detail information.
SummaryUser login account detail information.
I am customized a report to show user login and roles assignments. However, the user login account is set to "Inactive" but my sql statement still include the inactive user login. Please kindly advice.
SELECT U.USERNAME, RV.ROLE_NAME, RV.ROLE_COMMON_NAME
FROM PER_USERS U, PER_USER_ROLES UR, PER_ROLES_DN_VL RV
WHERE U.USER_ID(+) = UR.USER_ID AND UR.ROLE_ID (+) = RV.ROLE_ID AND UR.ACTIVE_FLAG = 'Y'