Oracle Basic Authentication Methods

You want to use a batch jobs so batch jobs should not have password embedded in the command line or script.
You can use Oracle Basic authentication methods for implementing no password login credentials.

sqlplus /nolog

conn / as sysdba
show parameters OS_AUTHENT_PREFIX

os_authent_prefix ops$

Alter system set OS_AUTHENT_PREFIX=’ ‘ scope=spfile;

shu immediate
startup

conn system/oracle
creed user zekeriya identified externally;
grant create session,resource to zekeriya;

operating system zekeriya is OS user
oracle$ su – zekeriya
password:****

zekeriya$ sqlplus /

select * from dual;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s