Privileges on views to query Oracle database-related data sources

SELECT privileges are required on certain views to query database-related data sources.
Table B-1 lists the view names that require SELECT privileges and the data sources that contain these views.
Data sources and the associated Views
Datasource name
View name
Database Application Contexts
DBA_CONTEXT
Database Audit Trail
DBA_AUDIT_TRAIL
Database Fine Grained Access Control Policies
DBA_POLICIES
Database Fine Grained Auditing Audit Trail
DBA_FGA_AUDIT_TRAIL
Database Initialization Parameters
V$SYSTEM_PARAMETER2
Database Links
DBA_DB_LINKS
Database Object Auditing
DBA_OBJ_AUDIT_OPTS
Database Object Privilege Assignments
SYS.OBJAUTH$, SYS.OBJ$, SYS.USER$, TABLE_PRIVILEGE_MAP, DBA_ROLES, DBA_OBJECTS, SYS.COL$
Database Objects
DBA_OBJECTS
Database Policy Contexts
DBA_POLICY_CONTEXTS
Database Policy Groups
DBA_POLICY_GROUPS
Database Privilege Auditing
DBA_PRIV_AUDIT_OPTS
Database Profiles
DBA_PROFILES
Database Resource Consumer Groups
DBA_RSRC_CONSUMER_GROUPS
Database Resource Limits
V$RESOURCE_LIMIT
Database Role Assignments
DBA_ROLE_PRIVS, DBA_ROLES
Database Roles
DBA_ROLES
Database Sessions
V$SESSION
Database Statement Auditing
DBA_STMT_AUDIT_OPTS
Database System Privilege Assignments
DBA_SYS_PRIVS, DBA_ROLES
Database Uniform Audit Trail
DBA_COMMON_AUDIT_TRAIL
Database User Tablespace Quotas
DBA_TS_QUOTAS
Database Users
  • DBA_USERS
  • PROXY_USERS
  • DBA_USERS_WITH_DEFPWD
Database and Instance Information
V$DATABASE ,V$INSTANCE, GLOBAL_NAME,V$VERSION
SQL*Plus Security
SYSTEM.PRODUCT_USER_PROFILE
UNIX and Linux Database File and Directory Permissions
v$system_parameter2, v$controlfile, v$datafile, v$logfile, V$tempfile v$archive_dest
Windows Database File and Folder Permissions
v$system_parameter2, v$controlfile, v$datafile, v$logfile, V$tempfile v$archive_dest