Q.RAA_OBJ_DIR_X

Look at the catalog_ids and owner names in Q.RAA_OBJ_DIR_X and display or fail to display each object based on the conditions below.

"Yes" to any of the following questions causes the query, procedure or form to be displayed in the list:
  1. Does the object owner match the current user ID?
  2. Does the object owner match the current SQLID?
  3. Does the object owner match the secondary authorization ID of the current user ID having the same catalog ID?
  4. Is the object SHARED? (Restricted = N)
  5. Is the user a SYSADM having the same catalog _ID?