A Look Inside Oracle's Data Dictionary
The examples in this section show you how to retrieve information from the data dictionary and are applicable to most relational database users, that is, system engineer, end user, or DBA. Oracle's data dictionary has a vast array of system tables and views for all types of database users, which is why we have chosen to explore Oracle's data dictionary in more depth.
User views are data dictionary views that are common to all database users. The only privilege a user needs in order to query against a user view is the CREATE SESSION system privilege, which should be common to all users.
Who Are You?
Before venturing into the seemingly endless knowledge contained within a database, you should know ...