Securing Scripts

[smallick]

How do I secure my db scripts from using imbeded passwords without using a fancy LDAP server on UNIX platform?

[marist89]

I like to use OS Authentication for my oracle userid. That way, you can login via:
sqlplus /@yourdatabase

Then, I grant dba privs to the ops$oracle user so he can run anything system can run...

[nealh]

Create a user with the same name as the operating system user:

create user identified externally;
grant connect to ;

You will be able to log into SQLPLUS without a password when you are logged on to UNIX as this user by typing:

sqlplus /

If you have problems, check the value of the parameter OS_AUTHENT_PREFIX. It should be blank.