Re: using sqlplus to login as a different user than os user.

Hi Ben,

From what you say I suspect that when users are created the IDENTIFIED EXTERNALLY clause is being used. If so, in order to do what you want you will have to create users without using the IDENTIFIED EXTERNALLY clause, e.g.

        CREATE USER foo IDENTIFIED BY foobar;

You can then use vi or emacs to create an executable script consisting of one
line:

        sqlplus foo/foobar

To launch a SQL*Plus session from the UNIX command line just type the name of the script file and press return.

Regards

Jerry

Ben Kim wrote:
>
> Hi,
> How can I login to Oracle under scott user id when
> my Unix user id is patty using sqlplus /
> I know that I can use os authentication, but my
> unix and oracle user ids are totally different as I described above.
> I thought there was a sqlplus hidden file that I could
> use so that when I type sqlplus /, sqlplus will read in
> both user id and password from this hidden file and
> allow me to login to oracle.
> Right now, our database is setup such that both
> unix and oracle user ids must be identical,
> and oracle user is identified externally.
> But this will not solve my problem because I need
> to make both Oracle and Unix ids totally different.
> Can someone help me?
> My e-mail address is dosa_at_tezcat.com
> thanks!!!
>
> --
> *******************************************************************
> * Ben Kim National Futures Asso. *
> * (847) 699-5000 Ext) 2984 Database Analysis *
> * E-mail dosa_at_tezcat.com *
> * bkim_at_nfa.futures.org *
> * http://www.tezcat.com/~dosa *
> *******************************************************************

--
Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.net Received on Tue Apr 14 1998 - 22:03:57 CDT