Catalog Views / Data Dictionary Views

The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:

The USER, ALL, and DBA, views show information about schema objects that are accessible to you, at different levels of privilege.
The V$ views show performance-related information.
The _PRIVS views show privilege information for different combinations of users, roles, and objects.

Shortcuts to View Names

If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.

List of Data Dictionary Views (A-Z)

ALL_COL_PRIVS: Syntax, Search for it

ALL_COL_PRIVS_MADE: Syntax, Search for it

ALL_COL_PRIVS_RECD: Syntax, Search for it

ALL_TAB_PRIVS: Syntax, Search for it

ALL_TAB_PRIVS_MADE: Syntax, Search for it

ALL_TAB_PRIVS_RECD: Syntax, Search for it

DBA_AQ_AGENT_PRIVS: Syntax, Search for it

DBA_COL_PRIVS: Syntax, Search for it

DBA_ROLE_PRIVS: Syntax, Search for it

DBA_RSRC_CONSUMER_GROUP_PRIVS: Syntax, Search for it

DBA_RSRC_MANAGER_SYSTEM_PRIVS: Syntax, Search for it

DBA_SYS_PRIVS: Syntax, Search for it

DBA_TAB_PRIVS: Syntax, Search for it

ROLE_ROLE_PRIVS: Syntax, Search for it

ROLE_SYS_PRIVS: Syntax, Search for it

ROLE_TAB_PRIVS: Syntax, Search for it

SESSION_PRIVS: Syntax, Search for it

USER_AQ_AGENT_PRIVS: Syntax, Search for it

USER_COL_PRIVS: Syntax, Search for it

USER_COL_PRIVS_MADE: Syntax, Search for it

USER_COL_PRIVS_RECD: Syntax, Search for it

USER_ROLE_PRIVS: Syntax, Search for it

USER_RSRC_CONSUMER_GROUP_PRIVS: Syntax, Search for it

USER_RSRC_MANAGER_SYSTEM_PRIVS: Syntax, Search for it

USER_SYS_PRIVS: Syntax, Search for it

USER_TAB_PRIVS: Syntax, Search for it

USER_TAB_PRIVS_MADE: Syntax, Search for it

USER_TAB_PRIVS_RECD: Syntax, Search for it

Copyright © 2016, Oracle and/or its affiliates. All rights reserved.