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.
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 |
|
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
|