Lesson 39 - Important system viewes

Important Views that each developer must know

 

USER_ERRORS  -  To list the current errors on the stored objects owned by the current user

USER_JOBS  -  - To list the jobs owned by the current user

USER_OBJECTS  - To list all objects owned by the current user

USER_ROLE_PRIVS  - To list the roles granted to the current user.

USER_SYNONYMS  - To list the private synonyms (synonyms owned by the current user)

USER_TABLES  - To listthe relational tables owned by the current user

USER_TAB_COLS  - To list the columns of the tables, views, and clusters owned by the current user

USER_TAB_MODIFICATIONS  - To list modifications to all tables owned by the current user that have been modified since the last time statistics were gathered on the tables.

USER_TAB_PRIVS  - To list the object grants for which the current user is the object owner, grantor, or grantee.

USER_TAB_PRIVS_MADE  - To list the object grants for which the current user is the object owner

USER_TAB_PRIVS_RECD  - To list the object grants for which the current user is the grantee.

USER_SYS_PRIVS  - To list system privileges granted to the current user

USER_TRIGGERS  - To list the triggers owned by the current user

USER_VIEWS  - To list the views owned by the current user

USER_CONSTRAINTS  - To list all constraint definitions on tables owned by the current user

USER_CONS_COLUMNS  - To list columns that are owned by the current user and that are specified in constraint definitions.

USER_DIMENSIONS  - To list dimension objects in the user's schema

USER_ENCRYPTED_COLUMNS –  maintains encryption algorithm information for all encrypted columns in all tables in the user's schema

USER_FREE_SPACE  - To list the free extents in the tablespaces accessible to the current user.

USER_INDEXES  - To list indexes owned by the current user

USER_IND_COLUMNS  - To list the columns of the indexes owned by the current user and columns of indexes on tables owned by the current user

USER_RESOURCE_LIMITS  - displays the resource limits for the current user.

USER_SEQUENCES  - To list all sequences owned by the current user

USER_SOURCE  - To list the text source of the stored objects owned by the current user

USER_LOBS  - displays the user's CLOBs and BLOBs contained in the user's tables