Query to retrieve Discoverer business areas, users and privileges
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