Oracle Privacy Security Auditing: Includes Federal Law Compliance with HIPAA, Sarbanes Oxley and the Gramm Leach Bliley Act GLB

Front Cover
Rampant TechPress, 2003 - Computers - 672 pages
0 Reviews
Sharing secrets for the effective creation of auditing mechanisms for Health/Insurance Portability and Accountability Act of 1996 (HIPAA) compliant Oracle systems, this book demonstrates how the HIPAA framework provides complete security access and auditing for Oracle database information. Complete details for using Oracle auditing features, including auditing from Oracle redo logs, using system-level triggers, and using Oracle9i fine-grained auditing (FGA) for auditing of the retrieval of sensitive information, are provided. Examples from all areas of auditing are covered and include working scripts and code snippets. Also discussed are the use of the Oracle9i LogMiner to retrieve audits of database updates and how to implement all Oracle system-level triggers for auditing, including DDL triggers, server error triggers, and login and logoff triggers.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Table of Contents
1
Introduction to HIPAA
13
In Summary
29
Introduction to Oracle Auditing
75
General Oracle Security
105
Multiple Sewer Areas
112
Showing the Process
129
Local OS Authentication
135
Advanced Networking Option
404
Final Checklist
410
General Oracle Auditing
417
Database Resident Audit Trail
423
Privilege Auditing
432
Shortcuts
439
Object Auditing
445
Data Dictionary Views for Auditing
455

Oracle Created Accounts
141
Object Privileges
157
System Privileges
168
Grants with Admin Option
180
SQLPlus Security
220
Final Checklist
230
dba_polides
255
User Defined Context
261
Summary
303
Key Management
339
Oracle Network Security
345
Oracle Network Management
353
Entering Passwords
362
Node Filtering
373
Connection Manager
385
Managing the Processes
391
dba_priv_audit_opts
478
Protecting the Audit Trail
487
Oracle System Event Trigger Auditing
511
Conclusion
540
System Privileges Granted to Roles
553
System Privileges Granted to Users
560
Conclusion
572
Prerequisite
578
Handler Procedure
585
HIPAA Compliance Oracle Solutions
621
Oracle lOg Enhancements
641
Relevant Columns
647
Conclusion
655
About Arup Nanda
662
Copyright

Other editions - View all

Common terms and phrases

About the author (2003)

Arup Nanda has been an Oracle DBA in areas such as design, modeling, performance tuning, and backup and recovery. Currently he is working on the HIPAA database design for a large U.S. national insurance company. He is a frequent speaker at Oracle-related conferences such as IOUG Live, has written several Oracle-related articles, and is on the editorial board for SELECT Journal, the publication of the International Oracle Users Group. He is the founder of Proligence, Inc., a company that provides specialized solutions on Oracle technologies such as replication, standby databases, security evaluations, and HIPAA implementations. He lives in Norwalk, Connecticut. Donald K. Burleson is the author of 16 Oracle database books and is the editor-in-chief of Oracle Internals. He is an Oracle consultant with extensive experience designing and implementing Oracle8 databases, including systems architecture, project management, data warehouse design, implementation and tuning, tuning massively parallel Oracle databases, Oracle SQL tuning, using Oracle with SAP, and tuning very large Oracle databases. He lives in Kittrell, North Carolina.

Bibliographic information