Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL for DBAs

What Else Does FGA Capture?

In the example query from the audit trial, I selected only the user who issued the SELECT statement and the SQL statement that was actually issued by the user. FGA records more information in the audit trail, most important of which is the time of the action. The TIMESTAMP column in the DBA_FGA_AUDIT_TRAIL view records the timestamp, which you will probably want to view using this format so you can see the full timestamp:

    TO_CHAR(TIMESTAMP,'mm/dd/yyyy hh24:mi:ss')

There are a number of other important columns that can be used to further establish the user’s identity and provide details on the action that was audited, all of which help in accountability and analysis. Key columns in this view include:

DB_USER

User who issued the statement.

SQL_TEXT

SQL statement the user issued.

TIMESTAMP

Time the user performed the action.

OS_USER

Operating system user who connected to the database.

USERHOST

Terminal or client machine from which the user is connected.

EXT_NAME

Sometimes the user is externally authenticated—for example, via LDAP; in such cases, the username in the external authentication mechanism is relevant and is captured in this column.

SQL_BIND

Values of the bind variables used in the query, if any.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page