|
|
|
As a DBA, you are responsible for auditing the database due to a suspicious transaction on certain table. An unknown user is deleting records and you have been assigned the task to investigate and find out who that person is.
Length:5 min 3 sec Date Submitted: 07/08/06 Hits: 203 Rating:  based on 0 votes
Auditing a database- Oracle DBA hands onAdded by Papergrl As a DBA, you are responsible for auditing the database due to a suspicious transaction on certain table. An unknown user is deleting records and you have been assigned the task to investigate and find out who that person is. Your job's responsibilities dictate that you should at least be informed of the following basic fundamental subjects: Starting auditing Stopping auditing Reading from the AUDIT TRAIL table Truncating the AUD$ table Using the AUDIT_TRAIL view Listing the AUDIT_TRAIL parameter Setting the AUDIT_TRAIL parameter Shutting down and startup a database using SPFILE Using the AUD$ table Auditing an auditor Auditing who deletes a record Viewing the AUD$ table Stopping all auditing trail Commands: TRUNCATE TABLE aud$ SHOW PARAMETER ALTER SYSTEM SET audit_trail=db SCOPE=spfile SHUTDOWN IMMEDIATE CONNECT system/manager AS SYSDBA STARTUP AUDIT delete ON sys.aud$ AUDIT DELETE ON BY ACCESS WHENEVER SUCCESSFUL NOAUDIT ALL You don't have permission to post replies. Please login or register. |