Saturday, June 18, 2011

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

Thanks to Juntaletras for sharing the script.

No comments: