RDBI.USER_ADMIN_VIEW_X

These SQL statements create the RDBI.USER_ADMIN_VIEW_X table.

CREATE VIEW RDBI.USER_ADMIN_VIEW_X
(
    CATALOG_ID,
    "AUTHID"
)
AS
SELECT B.ID, A."AUTHID"
FROM RDBI.ADMIN_VIEW A., RDBI.CATALOG_DIR_X B
WHERE A."AUTHID" IN (USER, CURRENT SQLID)
   OR A."AUTHID" IN (SELECT C.SECONDARY_ID
                     FROM RDBI.USER_AUTHID_VIEW_X C
                     WHERE B.ID = C.CATALOG_ID)