Re: Q: using sys account with secure oracle store (wallet)

From: Karl Arao <karlarao_at_gmail.com>
Date: Sun, 11 Oct 2009 21:05:57 +0800
Message-ID: <12ee65600910110605l5a05861br34f7fd30aa41a620_at_mail.gmail.com>



Yes this is available in 10gR2 using "Secure External Password Store"

You may want to read this
http://www.oracle-base.com/articles/10g/SecureExternalPasswordStore_10gR2.php in the example the scott user was used.

For SYS you should do the following command:

$mkstore -wrl $ORACLE_HOME/network/admin “<db connect string>” “SYS” <sys password>

This is ideal for hiding your passwords on the RMAN backup scripts and other maintenance operations.

Received on Sun Oct 11 2009 - 08:05:57 CDT

Original text of this message