Re: Still OS Authentication

Yes, that is exactly what I'm saying and thank you for your clarification.

I tried your examples and while logged into the OS as user "joe" I can connect with
"$ sqlplus ops\$joe/blow" and "SQL> connect ops$joe/blow" but still cannot connect with "$ sqlplus / "

Do OS groups which joe belongs to matter? User joe does not belong to the dba group but I didn't see anything in the documentation to lead me to believe that this was an issue. (I'd have tested that already but we're having phone line troubles so I can't use my dial-up)

Any ideas?

Thanks,
Roger Westbrook, rogue Sys Admin
Dollar General Corp

OraSaurus wrote:
>
> Roger Westbrook wrote:
> >
> > I presented this problem earlier and got some great responses but I'm
> > still not able to authenticate via the OS.
> >
> > Allow me to elaborate a little further...
> >
> > We are running Oracle 7.3.4 on AIX 4.1.5
> >
> > I added the line "os_authent_prefix=OPS$" to my initTEST.ora parameter
> > file.
> > I restarted the instance.
> > I created a new Oracle user with the following syntax..
> > create user OPS$user identified externally;
>
> I didn't see the start of this thread, but are you saying you did this,
> and then tryed, as the Unix user "user" to do "$ sqlplus / " and couldn't
> connect? (Some of the other replies I've seen seem to be talking about
> OS role authentication.)
>
> BTW: "identified externally" is not the key. It just makes it so that
> OS authentication is the only way you can connect. You can also do:
>
> "SQL> create user ops$joe identified by blow;"
>
> and the Unix user "joe" can now connect with "$ sqlplus / "
> Anyone can connect with "SQL> connect ops$joe/blow"
> or "$ sqlplus ops\$joe/blow".
>
> Really...
>
> -- OraSaurus
> --
> -- Remove "not_" to reply...
> --
Received on Sun Jan 24 1999 - 00:00:00 CET