Useful Shorthand Names for USER Views
| View Name | Synonym For |
|---|---|
| CAT | USER_CATALOG |
| COLS | USER_TAB_COLUMNS |
| IND | USER_INDEXES |
| OBJ | USER_OBJECTS |
| RECYCLEBIN | USER_RECYCLEBIN |
| SEQ | USER_SEQUENCES |
| SYN | USER_SYNONYMS |
| TABS | USER_TABLES |
The following table has USER Data Dictionary Views. Regular database users have access to these views.
| View Name | Description |
|---|---|
| USER_AUDIT_TRAIL | Audit trail entries |
| USER_CATALOG | Indexes, tables, views, clusters, synonyms, and sequences |
| USER_COL_COMMENTS | Comments on your columns |
| USER_COL_PRIVS | Column privileges |
| USER_COL_PRIVS_MADE | Column privileges you made |
| USER_COL_PRIVS_RECD | Column privileges you received |
| USER_CONS_COLUMNS | Columns involved in constraints |
| USER_CONSTRAINTS | All your constraints |
| USER_EXTENTS | All extents |
| USER_FREE_SPACE | Available free space for creating objects |
| USER_INDEXES | Description of all your indexes |
| USER_IND_COLUMNS | Description of all your index columns |
| USER_IND_EXPRESSIONS | Description of all your function-based index expressions |
| USER_MVIEWS | All your materialized views |
| USER_NESTED_TABLE_COLS | All columns of your nested tables |
| USER_NESTED_TABLES | All your nested tables |
| USER_OBJECTS | All your object descriptions |
| USER_RECYCLEBIN | Your recycle bin |
| USER_ROLE_PRIVS | Roles granted to you |
| USER_SEGMENTS | Storage-related information about your objects |
| USER_SEQUENCES | All your sequences |
| USER_SYNONYMS | All your synonym definitions |
| USER_SYS_PRIVS | System privileges you have |
| USER_TABLES | Description of your tables |
| USER_TAB_COLS | Description of your table columns |
| USER_TAB_COLUMNS | Description of your table columns, without hidden columns |
| USER_TAB_COMMENTS | Comments on your tables |
| USER_TAB_PRIVS | Table privileges where you are involved |
| USER_TAB_PRIVS_MADE | Table privileges you made |
| USER_TAB_PRIVS_RECD | Table privileges where you received |
| USER_TABLESPACES | Accessible tablespaces |
| USER_TS_QUOTAS | Quota for accessible tablespaces |
| USER_UPDATABLE_COLUMNS | Columns of updatable join views |
| USER_USERS | Information |
| USER_VIEWS | Description of all your views |