Re: OS Athentication

On Fri, 22 Jan 1999, Roger Westbrook wrote:
>
> I am attempting to enable OS Authentication for a few selected users and
> am having difficulties.
>
> I am running Oracle 7.3.4 on AIX 4.1.5.
>
> I've set the OS Auth prefix variable (I forget the exact var name at the
> moment but I pulled it out of the docs - even used cut and paste so I
> know it's not spelled wrong) in the init.ora for that instance. I took
> the standard "OPS$". I restarted the instance and added user "OPS$user"
> identified by external. Then, logged into the AIX as user "user", I
> tried to log into SQL*Plus (locally via telnet, not from client) like
> this... "sqlplus /" It denied access as invalid username and password.

I think you just set the password of the ops$user to "external." I think the syntax you want is

alter user ops$foobar identified externally; or create user ops$foobar identified externally;

--
Jeremiah Wilton      http://www.wolfenet.com/~jeremiah