Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips

HTML Text

 Home
 E-mail Us
 Oracle Articles



 Oracle Training
 Oracle News
 Oracle Forum
 Class Catalog


 Our Staff
 Our Prices
 Help Wanted!

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security
 UNIX
 Oracle UNIX
 Linux
 Oracle Linux
 Monitoring
 Remote help
 Remote plans
 Remote services
 Oracle C++
 Oracle Java
 Apache
 JDeveloper
 App Server
 Applications
 Oracle Forms
 Oracle Portal
 11i Upgrades
 SQL Server
 Oracle Concepts
 HTML-DB Tips
 Software Help
 Remote Help  
 Development  
 Implementation


 Financials Training
 Oracle 11i
 Oracle Apps 11i
 Oracle Workflow
 Oracle AR 11i Class
 Oracle AP 11i class
 Oracle GL 11i class
 Oracle HR 11i class
 Oracle FA 11i class
 11i Project Mgt
 11i procurement
 11i collections


  Oracle Posters
 Oracle Books
 Oracle Tuning Book
 Oracle RAC Book
 Oracle Security
  Easy Oracle Books
  Oracle Scripts
 SQL Server DBA
 SQL Design Patterns
 WISE
 Excel-DB   


 BC Oracle News


 Rednecks!
 Dress code
 Arabian Stallion
 Burleson Arabians
 Guide Horses
 Don Burleson Blog
 Golf & Travel


 Privacy Policy
 

 

  

Oracle Auditing
Intensive hands-on Oracle auditing

© 2007 by Burleson Consulting

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 
Key Features

* Understand the legal requirements for privacy auditing.

* See internals of Oracle auditing solutions.

* Employ system-level triggers to audit important Oracle events.

* Understand Virtual Private Databases.

* Use role-based security to ensure access rules.

* Learn about security exposures inside Oracle.

* Understand Oracle "Grant Execute" security.

* Learn how to plug backdoor access holes.

   

Course Description

Oracle Auditing is an intensive three-day course designed to provide auditing professionals with an in-depth understanding of how to audit all areas of Oracle databases.  Designed by a world-leading Oracle auditing professional and author of HIPAA Auditing for Oracle Database Security, this course teaches all areas of Oracle auditing including auditing Oracle security, auditing Oracle access controls, auditing Oracle recoverability, auditing data integrity, and auditing security exposures.

Book Required

 

Oracle Privacy Security Auditing
Includes Federal Law Compliance with HIPAA, Sarbanes-Oxley & The Gramm-Leach-Bliley Act GLB

Donald K. Burleson & Arup Nanda

Rampant TechPress, 2007

ISBN: 0-9727513-9-4 

Audience

This course is designed for practicing auditors with some IT technical skills.  Oracle experience is not helpful but students should have basic knowledge of SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.

Curriculum Design

This course is designed by Donald K. Burleson, an acknowledged leader in Oracle auditing techniques.  Burleson was chosen by Oracle Press to write four of the authorized Oracle Press editions on Oracle database management.   Burleson has 23 years of full-time DBA experience, is the author of 18 books, and serves as Editor-in-chief of Oracle Internals.

Learning Objectives

By the end of this course the student will be able to describe the methods for controlling security within an Oracle database, and understanding the concepts behind Oracle auditing for security, Oracle auditing for recoverability, Oracle HIPAA auditing, and Oracle auditing for data integrity.

Oracle Auditing
One-Day Overview
Syllabus

© 2007 by Donald K. Burleson
I. Database Auditing Evolution
 
Inside relational database access
 
            GRANT security
            Role-based security
            Grant execute security
            Virtual private databases
            Relational row-level security
 
Auditing access methods
 
            ODBC
            Access via pre-spawned shadow processes
            Using authentication servers
            OCI
            Web servers
            Procedural language compliers
 
 
II. Testing database access controls
 
Monitoring data access
            DDL auditing
            Auditing updates
            Auditing data privacy (HIPAA)
            Fine-grained auditing
 
The white Hat hacker
 
            Hacking IP addresses
            Bypassing database security
                        Reading flat files
            Cruising RAM
                        Forced Cobol SOC4 (mainframe)
                        ipcs on UNIX

 

 

  
III. Auditing database recoverability
 
Auditing backup & Recovery
                       
            Hot vs. Cold backups
            Managing redo logs, journals
 
            Proof of recoverability
 
            Disaster planning
 
 
                        Safe site
                        Hot site           
 
            Ensuring continuous availability
 
                        Standby databases
                        Replicated databases
                        Real Application clusters
 
 
IV. Auditing data integrity
 
            Referential integrity
 
                        Primary key constraints
Foreign key
                        Check constraints
                        Triggers
                       
            Auditing for redundant data
 
                        Materialized Views
                        Auditing replicated systems
                                    Snapshots
                                    Multimaster replication
 

 
  
 
 

Oracle Auditing
Three Day Class
Syllabus

© 2007 by Donald K. Burleson
 
DAY 1 – Introduction to Oracle auditing
 
1 – Introduction to database auditing
  • Review of course topics
  • Goals of database auditing
  • Auditing techniques for Oracle - Data dictionary
 2 - Introduction to Oracle SQL*Plus
  • Writing data dictionary queries
  • Spooling output
  • Editing SQL statements
  • Exercise - Write a basic SQL query report
3 - Writing Oracle audit scripts with SQL*Plus
  • Writing column formats
  • Computing sums and averages
  • Writing complex queries
  • Exercise - Write an audit report
4 – Basics areas of Oracle auditing
  • Oracle grant security auditing
  • Oracle grant execute security auditing
  • Oracle virtual private databases (fine-grained access control) auditing
  • Oracle data integrity auditing
  • Auditing Oracle recoverability
  • Auditing Oracle disaster recovery
5 – Oracle grant auditing
  • Overview of relational grant security
  • Review of the Oracle data dictionary (dba_role_privs, etc)
  • Exercise - Audit grant privileges
6 - Oracle grant execute security
  • Overview of grant execute security
  • Definer and invoker rights
  • Exercise create a package and stored procedure and grant rights
DAY 2 – Advanced Oracle security auditing
 
 1 - Auditing grant execute security
  • Overview of dba_objects and dba_source views
  • Dictionary views for grant execute security
  • Exercise - Audit grant execute access to packages, procedures & functions
2 - Oracle role-based security
  • Introduction to roles
  • stacking roles
  • assigning roles to users
  • Exercise - create roles & assign to users
  • Exercise audit role-based security
        

 

  
 
               3 – Problems with grant security
  • System privileges and object privileges
  • Overlapping data access
  • Using views with grant security
  • Exercise - Implement row-level and column level security with a view
 4 & 5– Oracle virtual private databases
  •  VPD basics
  • Exercise - Write a simple VPD and test it
6 – Auditing VPD security
  • VPD dictionary views
  •  Exercise - Write a VPD audit
DAY 3 – Oracle system auditing
 
1 - Auditing distributed databases
  • Oracle database links
  • Oracle distributed security
  • The two-phase commit
  • Exercise - Create a database link & audit access
2 – Oracle auditing for data integrity
  • Oracle DDL auditing
  • Oracle error auditing
  • Oracle referential integrity auditing
  • Exercise - Write a DDL audit trigger
3 - Oracle auditing for redundancy
  • Oracle materialized views
  • Oracle replication
  • Oracle snapshots
  • Oracle multi-master replication
  • Exercise - Audit scripts for distributed databases
 4 - Auditing recoverability
  • Oracle redo log management
  • Oracle failsafe
  • Oracle9i Dataguard
  • Oracle RAC and TAF
5 - Auditing data privacy (HIPAA)
  • Oracle audit SQL command
  • Viewing audit information
  • Exercise - Audit access to an Oracle table
6 - Oracle tools for data privacy
  • Oracle fine-grained auditing
  • Managing audit trails
  • Exercise - Write an FGA audit

 
 

Please note that while the knowledge gained from this Oracle training may be valuable when preparing for Oracle certification exams, the content of this course is not for Oracle Certification, including the Certified Professional (OCP) or Oracle Certified Associate (OCA) programs.

This is a BC Oracle training course (c) 2007
   
Hit Counter

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. 
Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.
 
 


Burleson Consulting

The Oracle of database support

 

Copyright © 1996 -  2007 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.