Oracle SQLPlus Command Line - Is There a Way to Encrypt the Password?

[ihda]

In Oracle 9i is there way to encrypt the command line password?

Thank you.

 

[LKBrwnDBA]

If you mean to be able to invoke sqlplus without having to type the password in the command line, then there are several ways:

1) OS authentication:
Specify EXTERNALLY option to create an external user. Such a user must be authenticated by an external service (such as an operating system or a third-party service). In this case, Oracle to relies on the login authentication of the operating system to ensure that a specific operating system user has access to a specific database user.
And invoke oracle utilities like this:

$ sqlplus /
$ sqlldr / control=...
$ exp / file=...
$ imp / file=...

2) In unix you can code something like this:

sqlplus <<EOF
MyUserid
myPasswd
@MyScript
EOF

3) Simply type the user id and sqlplus will prompt for password.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[sem]

You may tune sql*net to use secured connection.

Regards, Dima

http://seminihin.narod.ru