Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: embedding userid/password in scripts?
>John P DeVoy wrote:
Hi there,
You can create an OPS$ oracle account in your UNIX server and this will not use any user id or password.
For example, if your unix user is 'oracle' then you can create a following user in your database.
create user oracle identified externally;
Then as unix user oracle, you can logon to the database by supplying
sqlplus /
The advantage of this account is that, only oracle unix id can logon to the database and no one including the DBA will know the password. (the word externally is used to implement this).
Regards
N.Prabhakar Received on Sun Nov 17 1996 - 00:00:00 CST