Book Image

Oracle 11g Anti-hacker's Cookbook

By : Adrian Neagu
Book Image

Oracle 11g Anti-hacker's Cookbook

By: Adrian Neagu

Overview of this book

For almost all organizations, data security is a matter of prestige and credibility. The Oracle Database is one of the most rich in features and probably the most used Database in a variety of industries where security is essential. To ensure security of data both in transit and on the disk, Oracle has implemented the security technologies to achieve a reliable and solid system. In Oracle 11g Anti-Hacker's Cookbook, you will learn about the most important solutions that can be used for better database security."Oracle 11g Anti-hacker's Cookbook" covers all the important security measures and includes various tips and tricks to protect your Oracle Database."Oracle 11g Anti-hacker's Cookbook" uses real-world scenarios to show you how to secure the Oracle Database server from different perspectives and against different attack scenarios. Almost every chapter has a possible threads section, which describes the major dangers that can be confronted. The initial chapters cover how to defend the operating system, the network, the data and the users. The defense scenarios are linked and designed to prevent these attacks. The later chapters cover Oracle Vault, Oracle VPD, Oracle Labels, and Oracle Audit. Finally, in the Appendices, the book demonstrates how to perform a security assessment against the operating system and the database, and how to use a DAM tool for monitoring.

Related Content you might be interested in

Current Title:

Small book image
Oracle 11g Anti-hacker's Cookbook
Adrian Neagu
Oct, 2012 | 302 pages
No titles found
Table of Contents (16 chapters)
Oracle 11g Anti-hacker's Cookbook
Oracle 11g Anti-hacker's Cookbook
Credits
Credits
Foreword
Foreword
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Operating System Security
Operating System Security
Introduction
Using Tripwire for file integrity checking
Using immutable files to prevent modifications
Closing vulnerable network ports and services
Using network security kernel tunables to protect your system
Using TCP wrappers to allow and deny remote connections
Enforcing the use of strong passwords and restricting the use of previous passwords
Restricting direct login and su access
Securing SSH login
2
Securing the Network and Data in Transit
Securing the Network and Data in Transit
Introduction
Hijacking an Oracle connection
Using OAS network encryption for securing data in motion
Using OAS data integrity for securing data in motion
Using OAS SSL network encryption for securing data in motion
Encrypting network communication using IPSEC
Encrypting network communication with stunnel
Encrypting network communication using SSH tunneling
Restricting the fly listener administration using the ADMIN_RESTRICTION_LISTENER parameter
Securing external program execution (EXTPROC)
Controlling client connections using the TCP.VALIDNODE_CHECKING listener parameter
3
Securing Data at Rest
Securing Data at Rest
Introduction
Using block device encryption
Using filesystem encryption with eCryptfs
Using DBMS_CRYPTO for column encryption
Using Transparent Data Encryption for column encryption
Using TDE for tablespace encryption
Using encryption with data pump
Using encryption with RMAN
4
Authentication and User Security
Authentication and User Security
Introduction
Performing a security evaluation using Oracle Enterprise Manager
Using an offline Oracle password cracker
Using user profiles to enforce password policies
Using secure application roles
How to perform authentication using external password stores
Using SSL authentication
5
Beyond Privileges: Oracle Virtual Private Database
Beyond Privileges: Oracle Virtual Private Database
Introduction
Using session-based application contexts
Implementing row-level access policies
Using Oracle Enterprise Manager for managing VPD
Implementing column-level access policies
Implementing VPD grouped policies
Granting exemptions from VPD policies
6
Beyond Privileges: Oracle Label Security
Beyond Privileges: Oracle Label Security
Introduction
Creating and using label components
Defining and using compartments and groups
Using label policy privileges
Using trusted stored units
7
Beyond Privileges: Oracle Database Vault
Beyond Privileges: Oracle Database Vault
Introduction
Creating and using Oracle Database Vault realms
Creating and using Oracle Vault command rules
Creating and using Oracle Database Vault rulesets
Creating and using Oracle Database Vault factors
Creating and using Oracle Database Vault reports
8
Tracking and Analysis: Database Auditing
Tracking and Analysis: Database Auditing
Introduction
Determining how and where to generate audit information
Auditing sessions
Auditing statements
Auditing objects
Auditing privileges
Implementing fine-grained auditing
Integrating Oracle audit with SYSLOG
Auditing sys administrative users
Index
Index

Using OAS network encryption for securing data in motion

Oracle has built-in network encryption methods in its Oracle Advanced Security pack. The main advantage of using OAS encryption instead of other encryption methods is its ability to integrate and work with other Oracle security products such as Oracle Database Firewall and third-party products provided by other vendors such as IBM (InfoSphere Guardium), Imperva, and others. As a disadvantage, being a separate pack, it is expensive and requires licensing.

In case that you use unencrypted network communication, all the data flow from server to client will be sent in clear text. The only exception is the password which is sent in encrypted form during authentication. Packet interception becomes a trivial task if the attacker is located at the right place on the network and the data is transmitted unencrypted. In this recipe we will sniff and analyze the data in flight between nodeorcl5 and nodeorcl1 using Winshark. We will capture the...

Previous Section
End of Section 4
Next Section