DB2 Version 9.7 for Linux, UNIX, and Windows

OBJECTOWNERS administrative view - Retrieve object ownership information

The OBJECTOWNERS administrative view returns all object ownership information for every authorization ID of type USER that owns an object and that is defined in the system catalogs from the currently connected database.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:

SELECT privilege on the OBJECTOWNERS administrative view
CONTROL privilege on the OBJECTOWNERS administrative view
DATAACCESS authority

Example

Retrieve all object ownership information for object schema 'THERESAX'.

SELECT SUBSTR(OWNER,1,10) AS OWNER, OWNERTYPE,
   SUBSTR(OBJECTNAME,1,30) AS OBJECTNAME,
   SUBSTR(OBJECTSCHEMA,1,10) AS OBJECTSCHEMA, OBJECTTYPE
   FROM SYSIBMADM.OBJECTOWNERS WHERE OBJECTSCHEMA='THERESAX'

The following example is a sample output for this query.

OWNER      OWNERTYPE OBJECTNAME           OBJECTSCHEMA OBJECTTYPE
---------- --------- -----------------... ------------ ----------------
THERESAX   U         MIN_SALARY           THERESAX     TRIGGER
THERESAX   U         POLICY_IR            SYSTOOLS     TRIGGER
THERESAX   U         CUSTOMER             THERESAX     XML SCHEMA
THERESAX   U         DB2DETAILDEADLOCK                 EVENTMONITORS
THERESAX   U         SAMPSEQUENCE         THERESAX     SEQUENCE
THERESAX   U         SQLE0F00             NULLID       PACKAGE
...
THERESAX   U         HI_OBJ_UNIQ          SYSTOOLS     TABLE CONSTRAINT

  257 record(s) selected.

Information returned

Table 1. Information returned by the OBJECTOWNERS administrative view
Column name	Data type	Description
OWNER	VARCHAR(128)	Authorization ID that owns this object.
OWNERTYPE	VARCHAR(1)	Authorization ID type: U: user
OBJECTNAME	VARCHAR(128)	Database object name.
OBJECTSCHEMA	VARCHAR(128)	Database object schema.
OBJECTTYPE	VARCHAR(24)	Database object type.