USER_ views

USER_ data dictionary views provide metadata for all objects owned by the current user.

The following table provides an overview of the Oracle data dictionary views included in the USER_ group.

Function Description
USER_ARGUMENTS Provides information about the procedure and function arguments owned by the current user.
USER_COL_PRIVS Provides information about the column object grants for which the current user is the object owner, grantor, or grantee.
USER_CONS_COLUMNS Provides information about columns included in constraints and owned by the current user.
USER_CONSTRAINTS Provides information about table constraints owned by the current user.
USER_INDEXES Provides information about the indexes owned by the current user.
USER_OBJECTS Provides information about all database objects owned by the current user.
USER_PROCEDURES Provides information about all functions and procedures, along with associated properties, that are owned by the current user.
USER_SYNONYMS Provides information about the synonyms owned by the current user.
USER_TAB_COLUMNS Provides information about the columns of the tables, views, and clusters owned by the current user.
USER_TAB_PRIVS Provides information about the object grants for which the current user is the object owner, grantor, or grantee.
USER_TABLES Provides information about the relational tables owned by the current user.
USER_USERS Provides information about the current user.
USER_VIEWS Provides information about the views owned by the current user.