Auditing Capabilities
Auditing, in Oracle, is used to assist the DBA with investigating suspicious database activity or to gather information about certain specific database activities.
You may determine that an unauthorized user is deleting data. In that case, the DBA, or a security administrator, might decide that she needs to audit all the connections to the database and all the successful or unsuccessful deletions of data from all the tables in the database for a given period of time. Oracle provides facilities to enable the DBA to gather statistics not only on who has been connecting to the database to learn about the unauthorized deletions but also to gather information on how many logical I/O operations have been performed at peak times ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
