VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Secure External Password Store using wallet

Posted by admin on 5th January 2012

Oracle Wallet的使用

最近看到一封邮件,该网友提出了如下需求:

This is not exactly an Oracle question, but I am asking it here in case
someone has solved this. We have alot of jobs that log into our Oracle
databases. Some of them use ops$oracle accounts. In the future we are not
allowed to use ops$oracle and need to provide passwords. I am trying to
find a method, or program/script that allows us to do the following.
1. store oracle passwords in unix in a lock box
2. only given processes and users can access specific passwords
3. program/process/script has customizable logic that only lets specific jobs access the password.
4. We are mainly using Cron for our jobs, but may be using some other job schedulers in the future that have morefeatures.
5. you cannot access the passwords from a user account

这种需求用oracle wallet实现是一个不错的选择

oracle wallet是一个加密的RKCS#12文件

++CoolCode_BLOCK_2[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Oracle 登录方式以及验证

Posted by admin on 30th November 2011

数据库用sysdba登录的验证有两种方式,一种是通过os认证,一种是通过密码文件验证;登录方式有两种,一种是在数据库主机直接登录(用os认证的方式),一种是通过网络远程登录;需要设置的参数有两个,一个是SQLNET.AUTHENTICATION_SERVICES,一个是REMOTE_LOGIN_PA[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »