RDBI.USER_ADMIN_VIEW_X

The following 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)