All the tables that contain information about the database are created by Oracle and their names start with DBA_
, ALL_
or USER_
.
DBA_
views contain all the information about the database and are accessible to users with the DBA
role.
ALL_
views contain all the information about the database that the current user has access to.
USER_
views contain all the information about the database that the current user owns.