Query to retrieve Discoverer business areas, users and privileges

Query to retrieve Discoverer business areas, users and privileges, AskHareesh blog for Oracle Apps

Query to retrieve Discoverer business areas, users and privileges

SELECT
        EU_USERNAME
FROM
        EUL5_EUL_USERS A,
        EUL5_ACCESS_PRIVS B,
        EUL5_BAS C
WHERE
        A.EU_ID = B.AP_EU_ID
        AND B.GBA_BA_ID = C.BA_ID
        AND C.BA_NAME = --- BA_NAME

*/