Index

A C D E F G H I J M N O P R S T U W

A

account management events

Oracle Database, B.2

report, 3.4.1

SQL Server, C.2

administrative changes

successful, 3.6.2

agents, collection

checking status, 1.5

alerts

about, 2.11.1

activity summary, 2.11.3

advanced, 2.11.2.3

basic, 2.11.2.2

creating, 2.11.2

how they are raised, 2.11.3

listing, 2.11.2.1

monitoring, 2.11.3

rules, creating, 2.11.2.1

All Alerts Report, 3.7.1

application management events

Oracle Database, B.3

reports, 3.4.4

SQL Server, C.3

audit command events

Oracle Database, B.4

report, 3.4.2

SQL Server, C.4

audit events

Microsoft SQL Server, listed, C.1

Oracle Database Vault, B.6

Oracle Database, listed, B.1

C

capture rules

See redo log files

D

data access events

Oracle Database, B.5

Oracle Database Vault, B.6

report, 3.3.2

SQL Server, C.5

data warehouse schema

about, A.1

architecture, A.2

design, A.3

dimension tables, A.4

fact tables

about, A.4

AUDIT_EVENT_FACT table, A.6.1

CLIENT_HOST_DIM table, A.6.2

CLIENT_TOOL_DIM table, A.6.3

constraints, A.5

CONTEXT_DIM table, A.6.4

EVENT_DIM table, A.6.5

indexes, A.5

PRIVILEGES_DIM table, A.6.6

relationships, A.6

SOURCE_DIM table, A.6.7

TARGET_DIM table, A.6.8

TIME_DIM table, A.6.9

USER_DIM table, A.6.10

data, changed by INSERT, UPDATE, DELETE

report, 3.6.4

Database Vault

See Oracle Database Vault

databases

audit policies

copying to another database, 2.10

exporting to source database, 2.9

retrieving from, 2.2.1

distributed, tracking with Distributed Database Report, 3.3.4

monitoring database source, 1.5

DDL report audit events

report, 3.6.5

default settings in reports, reverting to, 3.8.8

E

event activity summary, 2.11.3

event handlers

fine-grained auditing, 2.6.1.2

relevant columns, used with, 2.6.1.2

exception events

Oracle Database, B.7

SQL Server, C.6

exceptional event events

report, 3.5.1

F

failed attempts

administrative, 3.6.1

filtering data in reports, 3.8.3

fine-grained auditing, 2.6.1

about, 2.6.1

audit policy, defining, 2.6.2

event handlers, 2.6.1.2

relevant columns, 2.6.1.1

G

general tasks for auditors using Oracle Audit Vault, 1.2

H

hiding columns in reports, 3.8.2

highlighting data in reports, 3.8.5

Home page

alert monitoring, 2.11.3

I

invalid record events

Oracle Database, B.8

report, 3.5.2

SQL Server, C.7

J

join operations

filtering row data, 3.8.3

M

master records, pulling column from report, 3.8.7

Microsoft SQL Server

audit events

about, C.1

listed, C.1

requirements for audit data collection, 1.3.2

N

null values

sorting in reports, 3.8.4.2

O

object access audit events

report, 3.6.8

object management events

Oracle Database, B.9

report, 3.4.3

SQL Server, C.8

objects

See schema object auditing

Oracle Audit Vault

about, 1.1

audited data, types of, 1.2.2

general tasks for auditors, 1.2

Microsoft SQL Server database requirements, 1.3.2

Oracle database requirements, 1.3.1.1

Oracle Database

audit events

about, B.1

listed, B.1

audit settings, recommended in the database, 1.3.1.2

requirements for audit data collection, 1.3.1.1

Oracle Database Vault events

report, 3.3.3

Overview page

displaying, 2.11.3

P

peer association events

Oracle Database, B.10

report, 3.3.4

SQL Server, C.9

privilege auditing

about, 2.5.1

audit policy, defining, 2.5.2

statement auditing, how more focused than, 2.5.1

procedures

See SQL statements, SQL statement auditing

R

redo log file auditing

about, 2.7.1

audit policy, defining, 2.7.2

relevant columns

about, 2.6.1.1

event handlers, used with, 2.6.1.2

fine-grained auditing, used in, 2.6.1.1

reports

about, 3.1

accessing, 3.2

charts, creating, 3.8.6

checking data collection status, 1.5

columns

control break, adding, 3.8.7

finding information about, 3.9.2

hiding current column, 3.8.2.1

hiding or showing, 3.8.2.2

customizing data display, 3.8

data collected for, 3.1

filtering

all rows based on current column, 3.8.3.1

rows in one or all columns, 3.8.3.2

using an expression, 3.8.3.3

finding information

audit records, 3.9.1

column descriptions, 3.9.2

highlighting rows, 3.8.5

resetting display values to defaults, 3.8.8

saving to CSV file, 3.11

sorting data

all columns, 3.8.4.2

current column, 3.8.4.1

who can access, 3.1

See also reports, default and reports, user-defined

reports, default

Access Reports, 3.3

Account and Role Changes, 3.6.2

Account Management Report, 3.4.1

alert reports, 3.7

All Alerts Report, 3.7.1

Audit Command Report, 3.4.2

Changes to Audit Report, 3.6.3

compliance reports, 3.6

Critical Alerts Report, 3.7.2

Data Access Report, 3.3.2

Data Change Report, 3.6.4

Database Vault Report, 3.3.3

DDL Report, 3.6.5

Distributed Database Report, 3.3.4

Exception Report, 3.5.1

Invalid Audit Record Report, 3.5.2

Management Activity Reports, 3.4

Object Access Report, 3.6.8

Object Management Report, 3.4.3

Procedure Executions Report, 3.3.5

Procedure Management Report, 3.4.4

Role and Privilege Management Report, 3.4.5

Security Account and Role Changes - Blocked Report, 3.6.1

System Events Report, 3.6.9

System Exception Reports, 3.5

System Management Report, 3.4.6

Uncategorized Activity Report, 3.5.3

User Sessions Report, 3.3.6

Warning Alerts Report, 3.7.3

See also reports, and user-defined reports

reports, user-defined

accessing, 3.10.4

categories, creating, 3.10.2

creating, 3.10.3

S

Sarbanes-Oxley (SOX) Act

privilege auditing, how it meets compliance, 2.5.1

saving a report to CSV file, 3.11

schema object auditing

about, 2.4.1

audit policy, defining, 2.4.2

service and application utilization events

Oracle Database, B.12

report, 3.3.5

SQL Server, C.11

showing columns in reports, 3.8.2

sorting data in reports, 3.8.4

SQL statement auditing

about, 2.3.1

audit policy, defining, 2.3.2

privilege auditing, compared with, 2.5.1

Procedure Executions Report, 3.3.5

Procedure Management Report, 3.4.4

starting Audit Vault Console, 1.4

statements

See SQL statements, SQL statement auditing

subqueries

filtering row data, 3.8.3

system audit events

reports, 3.6.9

system management events

Oracle Database, B.13

report, 3.4.6

SQL Server, C.12

T

troubleshooting

database auditing not enabled, 1.3

Database Vault report not showing data, 3.3.3

no data in reports, 1.5

source database not available, 1.5

U

unknown or uncategorized events

Oracle Database, B.14

report, 3.5.3

SQL Server, C.13

user login failure audit events

report, 3.6.6

user session events

Oracle Database, B.15

report, 3.3.6

SQL Server, C.14

user-defined reports

deleting, 3.10.4

users

failed administrative attempts, report, 3.6.1

W

Warning Alerts Report, 3.7.3

Windows Event Viewer

audit events logged in, C.4

exception events logged in, C.6