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:
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.