Oracle External Secure Password Store

External Secure Password Store
================================

Use the mkstore command:

•  Create the wallet:

mkdir /u01/app/oraclel/wallets

mkstore -wrl <wallet_location> -create

mkstore -wrl /u01/app/oraclel/wallets -create

•  Add credentials to the wallet:

$ mkstore -wrl /u01/app/oraclel/wallets -create
Enter password: <wallet_password>
Enter password again: <wallet_password>

mkstore -wrl /u01/app/oracle/client_wallets -createCredential dev hr hr

Configure sqlnet.ora
=====================
Set the following in sqlnet.ora:
• WALLET_LOCATION
• SQLNET.WALLET_OVERRIDE

WALLET_LOCATION =
  (SOURCE=
   (METHOD=File)
    (METHOD_DATA=
     (DIRECTORY=/u01/app/oraclel/wallets)))

SQLNET.WALLET_OVERRIDE = TRUE

Managing the External Password Store
=====================================

To list the contents of the external password store, enter the following command at the command line:
mkstore -wrl <wallet_location> -listCredential

To add database login credentials to an existing client wallet, enter the following command:

mkstore -wrl <wallet_location> -createCredential <db_alias> <username> <password>

To modify database login credentials, enter the following command:

mkstore -wrl <wallet_location> -modifyCredential <dbase_alias> <username> <password>

To delete database login credentials, enter the following command:

mkstore -wrl <wallet_location> -deleteCredential <db_alias>