USER_OBJECTS v11
The USER_OBJECTS view provides information about all objects that are owned by the current user.
| Name | Type | Description |
|---|---|---|
schema_name | TEXT | Name of the schema in which the object belongs. |
object_name | TEXT | Name of the object. |
object_type | TEXT | Type of the object – possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW |
status | CHARACTER VARYING | Included for compatibility only; always set to VALID. |
temporary | TEXT | Y if the object is temporary; N if the object is not temporary. |