Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Using certificates for authentication


Using a simple password as a means to authenticate a database user is a weak authentication method. A stronger authentication method can be achieved with certificates, this requires the advanced security to be installed and configured.

Public Key Infrastructure tools

The Oracle database Public Key Infrastructure(PKI) implementation requires:

  • Oracle Advanced Security

  • Oracle Identity Management Infrastructure

  • Oracle Wallet Manager

  • Enterprise Security Manager

The procedure to configure authentication is as follows:

  1. 1. Install the PKI Tools.

  2. 2. Configure SSL on the server side. Store a certificate in the Wallet at the server side.

  3. 3. Configure the network configuration files listener.ora and sqlnet.ora on the server side so it supports SSL

  4. 4. Configure the client network files, sqlnet.ora and tnsnames.ora so it supports SSL.

  5. 5. Create a user whose authentication is performed with a certificate.