Re: How to hide sqlplus login/passwd

Here's some info from another thread. It says to use /nolog.

From the SQLPLUS manual:

Syntax

SQLPLUS [[-S[ILENT]] [logon] [start]]|-?

where:

logon

Requires the following syntax:

username[/password] [@database_specification]|/|/NOLOG

start

Allows you to enter the name of a command file and arguments. SQL*Plus passes the arguments to the command file as though you executed the file using the SQL*Plus START
command. The start clause requires the following syntax:

@file_name[.ext][arg ...]

See the START command in this chapter for more information.

Terms and Clauses

You have the option of entering logon. If you do not specify logon and do specify start, SQL*Plus assumes that the first line of the command file contains a valid logon. If neither start nor logon are specified, SQL*Plus prompts for logon information.

Refer to the following list for a description of each term or clause:

username[/password]

Represent the username and password with which you wish to start SQL*Plus and connect to Oracle. If you omit username and password, SQL*Plus prompts you for them. If you enter
a slash (/) or simply enter [Return] to the prompt for username, SQL*Plus logs you in using a default logon (see "/" below).

If you omit only password, SQL*Plus prompts you for password. When prompting, SQL*Plus does not display password on your terminal screen.

/

Represents a default logon using operating system authentication. You cannot enter a database_specification if you use a default logon. In a default logon, SQL*Plus typically attempts
to log you in using the username OPS$name, where name is your operating system username. See the Oracle7 Server Administrator's Guide for information about operating system
authentication.

/NOLOG Establishes no initial connection to Oracle. Before issuing any SQL commands, you must issue a CONNECT command to establish a valid logon. Use /NOLOG when you want to have a
SQL*Plus command file prompt for the username, password, or database specification. The first line of this command file is not assumed to contain a logon.

Marti Rijken wrote:

> esiyuri_at_my-dejanews.com <esiyuri_at_my-dejanews.com> wrote:
> >
> >I've been using Oracle for many years, but have never heard of a '/nolog'
> >option. Is it operating system specific?
>
> I didn't know it either. And as far as the help from `sqlplus -?` goes,
> it is undocumented.
> But I found out that `slqplus /nolog` gives you the SQL-prompt, without
> asking for username/password. But the session is one without connection
> to Oracle, so a "connect" is necessary to do something usefull.
> At least this is the behaviour on HP-UX.
>
> --
> @..@ Marti Rijken <mrijken_at_prv.gelderland.nl>
> (`--') private mail: mrijken_at_natrix.demon.nl
> ( }..{ ) URL: http://www.natrix.demon.nl/

"Andrey A. Kulaga" wrote:

> starek_at_pluto.spsselib.hiedu.cz (Roman Starek) writes:
>
> > Hi
> >
> > answer is simple. Create some file with your login name and password
> > and execute this one from emacs. Everyone will be able to see only name of
> > this file, but contents of this file should be readable only for you. On
> > Unix platform use chmod command to do this.
> >
> >
> > Best regards
> > Starous
>
> I do so. My script contains one line:
>
> sqlplus -s login/password @$1
>
> and it is set -rwx------
>
> However, when it is running, ps -ef shows string with login/password.
Received on Fri Dec 11 1998 - 11:29:30 CST