Q.RAA_OBJECT_VIEW_X

For queries, forms, and procedures, the view Q.RAA_OBJECT_VIEW_X is the key and it interacts with the other views and tables, as shown below.

Note: This view is for the Object Listing Option:

"Include only those objects that any of the user's primary or 
secondary authorization IDs are authorized to access. This option 
requires the most database resources when producing lists."

The following SQL statements create this view:

CREATE VIEW Q.RAA_OBJECT_VIEW_X
(
       CATALOG_ID,
       OWNER, NAME, TYPE, SUBTYPE, OBJECTLEVEL, RESTRICTED, MODEL,
REMARKS
       DELETED_BY_USER, DELETED_BY_SQLID, DELETED_TIMESTAMP
)
AS
SELECT A.CATALOG_ID,
       A.OWNER, A.NAME, A.TYPE, A.SUBTYPE,
       A.OBJECTLEVEL, A.RESTRICTED, A.MODEL,
       B.REMARKS,
       A.DELETED_BY_USER, A.DELETED_BY_SQLID, A.DELETED_TIMESTAMP
FROM Q.RAA_OBJ_DIR_X A, Q.RAA_OBJ_REM_X B
WHERE (A.CATALOG_ID = B.CATALOG_ID AND
       A.OWNER = B.OWNER AND
       A.NAME = B.NAME AND
       A.DELETED_TIMESTAMP IS NULL AND B.DELETED_TIMESTAMP IS NULL)
 AND (A.RESTRICTED ='N'
       OR A.OWNER IN (USER, CURRENT SQLID)
       OR A.OWNER IN (SELECT C.SECONDARY_ID
                      FROM RDBI_USER_AUTHID_VIEW_X C
                      WHERE C.CATALOG_ID = A.CATALOG_ID)
       OR EXISTS (SELECT D.AUTHID
                  FROM RDBI.USER_ADMIN_VIEW_X D
                  WHERE D.CATALOG_ID = A.CATALOG_ID))