Re: database password

Hello Michael,

your question is some years old in the meantime: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:142212348066

You can also use "Oracle Wallet". The following extract is taken from http://www.oracle.com/technology/deploy/security/database-security/pdf/twp_security_db_database_10gr2.pdf

"

BATCH JOBS: PROTECTION OF USERNAME AND PASSWORD Oracle Database 10g Release 2 introduces new functionality to dramatically improve the security of batch jobs which use a username and password to connect to the Oracle database. Historically, Oracle Wallets have been used to manage PKI credentials for authentication to the Oracle database. Starting with Oracle Database 10g Release 2, Oracle Wallets can be used to store a username and password. This enables a user to simply use a "/" to connect to the database, but still authenticate using a username and password. sqlplus /@prodapp
This new capability will address the issue with exposing username and passwords on unix systems when executing the ps -ef command. This new feature is also useful for jobs which need to connect from a middle tier using a username and password and run a batch job within an application schema.
"

Best regards
Ronny Received on Thu May 17 2007 - 07:21:47 CDT