How to perform authentication using external password stores

External password stores are useful in situations in which you want to prevent the connection credentials from being exposed in scripts or application code. In this recipe, we will create a password store that will contain the password for the HR user.

Getting ready

The steps in this recipe will be performed on the HACKDB database and the client node nodeorcl5.

How to do it...

During this recipe, we will use the mkstore utility for wallet management:

1. Create the wallet by using the mkstore utility. Use ly8T%QX;r for the wallet password as follows:

   mkstore -wrl  /security/wallets/pass_store -create
   Oracle Secret Store Tool : Version 11.2.0.3.0 - Production
   Copyright (c) 2004, 2011, Oracle and /or its affiliates. All rights reserved.
   
   Enter password:
   
   Enter password again:
   

2. Create a net service name used for working with the password store, as follows:

   HACKDB_PASS_STORE =
     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL ...