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.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
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'
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.
Column name | Data type | Description |
---|---|---|
OWNER | VARCHAR(128) | Authorization ID that owns this object. |
OWNERTYPE | VARCHAR(1) | Authorization ID type:
|
OBJECTNAME | VARCHAR(128) | object_name - Object name monitor element |
OBJECTSCHEMA | VARCHAR(128) | object_schema - Object schema monitor element |
OBJECTTYPE | VARCHAR(24) | Database object type. |