
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
No comments:
Post a Comment