Oracle Discoverer EUL Tables & Description

EUL Tables Information:

EUL4_BAS
Table gives list of Business Areas

EUL4_OBJS
Table gives all folders in the EUL

EUL4_KEY_CONS
Table gives all Folder Joins details.
- Key_Obj_ID points to parent folder,
- FK_Obj_ID_Remote points to child folder

EUL4_EXPRESSIONS
Table gives all Items that are in the EUL
- IT_Obj_ID is not null AND join to a row in EUL4_Objs you have a Folder Item.
They are listed as Exp_Type of 'CO' or 'CI'.
COs are database object items.
CIs are created items (like date hierarchy items, complex folder items, etc).

EUL4_OBJS
Table gives details about the types of objects
- Obj_Type tells you Standard (SOBJ) from Complex (COBJ) folders.

EUL_USERS
Table gives user details.

EUL4_ACCESS_PRIVS
Table to use to get the list of Discoverer users that was granted access to the User Edition.
Basically, when a user has been granted privileges one row per privilege is inserted into this table.
- The column called AP_EU_ID contains the ID of the user.
- The column GP_APP_ID is the one that tells you what privilege a user has.