Re: Still OS Authentication

Hi,

Try this syntax in the inittest.ora file;

os_authent_prefix = "OPS$"
or
os_authent_prefix = ""

depending on whether you require a prefix or not.

also try;

remote_os_authent = TRUE

This is usefull when the client is authenticating against a remote OS.

Also make sure if you are connecting over sqlnet that the following line is not in the servers or clients sqlnet.ora file.

sqlnet.authentication_services = (NONE)

Hope this is of some help...

Regards,

--
Daniel
Oracle UK



>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 created the AIX user "user"

>I verified that dba_tables does in fact list user OPS$user as external

>I verified that the AIX user has the correct ORACLE_SID and has the

>correct path variables.

>

>Using the AIX user "user" I can successfuly log into sqlplus with the

>following syntax

>sqlplus system/manager

>This only works so long as I specify a valid database authenticated

>username and password.

>

>However, I fail to connect to sqlplus using the following syntax...

>sqlplus /

>

>All of this takes place locally via telnet session.

>

>The documentation says only that I need to set the OS auth prefix in the

>init.ora parameter file and restart the instance.  Then I should be able

>to connect to the database with an OS user who's name matches the part

>of the Oracle username which follows OPS$.  The example it gives is

>"sqlplus /" but this isn't working for me.

>

>Can anyone tell me what I'm missing?

>

>Thanks in advance! (again)

>Roger Westbrook, rogue Sys Admin

>Dollar General Corp

>please reply to   rwestbrook_at_dollargeneral.com

>

>>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.

>>

>>What am I missing here?

>>

>>Thanks in advance!

>>Roger Westbrook, rogue Sys Admin

>>Dollar General Corp

>>

>>Please reply-to  rwestbrook_at_dollargeneral.com