Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: User passwords under NT & Oracle 8.0.4.0.0

Re: User passwords under NT & Oracle 8.0.4.0.0

From: Rick Wessman <rwessman_at_us.oracle.com>
Date: 27 Apr 1999 14:23:08 -0400
Message-ID: <un1ztly7n.fsf@us.oracle.com>


"Kenny Gump" <kgump_at_mylanlabs.com> writes:

> You will need to set OS_AUTHENT_PREFIX = OPS$ in your init.ora file then
> create the user as follows:

It doesn't need to be set to this specific value. I suggest setting it to "". That way, you can have longer user names.

>
> create user ops$jsmith
> identified externally
> ....;

If OS_AUTHENT_PREFIX is set to "", then this statement would be: create user jsmith identified externally;

>
> Now user jsmith can log in from his terminal with Windows doing the
> authentication.
>
> Kenny Gump
>
> Evert J. Smit wrote in message <7fvlsm$p6r$1_at_news.kabelfoon.nl>...
> >How can I let the people, in our factory, to connect with the database
> >(Oracle 8.0.4.0.0 unde NT4) with the same password as the one which they
> log
> >in during windows startup.
> >
> >I know that it's possible with something like OS_AUTHENT_PREFIX but I've no
> >idea how to set this up.

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com
Received on Tue Apr 27 1999 - 13:23:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US