RelationalDBDesign RelationalDBDesign


Creating Users   «Prev 

Viewing user Information

DBA_USERS, DBA_SYS_PRIVS, DBA_TS_QUOTAS

Viewing user information for 1) DBA_USERS, 2) DBA_SYS_PRIVS, 3) DBA_TS_QUOTAS
  1. DBA_USERS: The DBA_USERS view returns one row for each user in the database. Use this view to find out about default and temporary tablespace assignments, profile assignments, account creation date, and password expiration date.
  2. DBA_SYS_PRIVS: The DBA_SYS_PRIVS view returns information about system privileges that have been granted to a user.
  3. DBA_TS_QUOTAS: The DBA_TS_QUOTAS view returns information about a user's quotas on tablespaces in the database.

Oracle Data Dictionary Concepts

The following static data dictionary views are new in the release of Oracle 12c:
-- ALL_CLUSTERING_DIMENSIONS, DBA_CLUSTERING_DIMENSIONS, and
USER_CLUSTERING_DIMENSIONS
This initialization parameter was introduced in Oracle Database 11g Release 2 (11.2.0.4), but is available for the first time in Oracle Database 12c with Oracle Database 12c Release 1 (12.1.0.2).
-- ALL_CLUSTERING_JOINS, DBA_CLUSTERING_JOINS, and
USER_CLUSTERING_JOINS
-- ALL_CLUSTERING_KEYS, DBA_CLUSTERING_KEYS, and
USER_CLUSTERING_KEYS
-- ALL_CLUSTERING_TABLES, DBA_CLUSTERING_TABLES, and
USER_CLUSTERING_TABLES
-- ALL_JSON_COLUMNS, DBA_JSON_COLUMNS, and USER_JSON_COLUMNS
-- ALL_ZONEMAP_MEASURES, DBA_ZONEMAP_MEASURES, and
USER_ZONEMAP_MEASURES
-- ALL_ZONEMAPS, DBA_ZONEMAPS, and USER_ZONEMAPS
-- DBA_HIST_IM_SEG_STAT
-- DBA_HIST_IM_SEG_STAT_OBJ
-- DBA_PDB_SAVED_STATES
-- DBA_ROLLING_UNSUPPORTED