Lecture "Database security and auditing - Protecting data integrity and accessibility - Chapter 9: Auditing database activities" presentation of content: Audit server activities with Microsoft SQL Server 2000, audit database activities using Microsoft SQL Profiler, use SQL Server for security auditing. Mời các bạn tham khảo. | Database Security and Auditing: Protecting Data Integrity and Accessibility Chapter 9 Auditing Database Activities Database Security and Auditing 2 Objectives Use Oracle database activities Learn how to create DLL triggers with Oracle Audit database activities using Oracle Database Security and Auditing 3 Objectives (continued) Audit server activities with Microsoft SQL Server 2000 Audit database activities using Microsoft SQL Profiler Use SQL Server for security auditing Database Security and Auditing 4 Using Oracle Database Activities Several types of activities: Application activities: SQL statements issued against application tables Administration activities: commands issued for maintenance and administrative purposes Database events: events that occur when a specific activity occurs Database Security and Auditing 5 Creating DDL Triggers with Oracle Audit program provides: Audit trail for all activities Opportunity for using process controls Database activities statements (in addition to DML): Data Definition Language (DDL) Data Control Language Database events SQL statements audit trail Database Security and Auditing 6 Creating DDL Triggers with Oracle (continued) Use CREATE TRIGGER: DDL statements Database events Database Security and Auditing 7 Example of LOGON and LOGOFF Database Events Steps: Log on as SYSTEM Create the APP_AUDIT_LOGINS table Create two triggers: One that fires after the logon event One that fires before the logoff event Log on as DBSEC; disconnect after a few minutes Log on as SYSTEM to check the auditing table Database Security and Auditing 8 DDL Event Example Steps: Log on as SYSTEM Create a trigger that fires before an ALTER statement is completed Log on as DBSEC and alter a table Pseudocolumns: ora_dict_obj_name ora_dict_obj_owner ora_sysevent Database Security and Auditing 9 Auditing Code with Oracle Steps: Log on as DBSEC Create an auditing table Create a table and populate it with two records Create a trigger to track code Update . | Database Security and Auditing: Protecting Data Integrity and Accessibility Chapter 9 Auditing Database Activities Database Security and Auditing 2 Objectives Use Oracle database activities Learn how to create DLL triggers with Oracle Audit database activities using Oracle Database Security and Auditing 3 Objectives (continued) Audit server activities with Microsoft SQL Server 2000 Audit database activities using Microsoft SQL Profiler Use SQL Server for security auditing Database Security and Auditing 4 Using Oracle Database Activities Several types of activities: Application activities: SQL statements issued against application tables Administration activities: commands issued for maintenance and administrative purposes Database events: events that occur when a specific activity occurs Database Security and Auditing 5 Creating DDL Triggers with Oracle Audit program provides: Audit trail for all activities Opportunity for using process controls Database activities statements (in .
