Home » RDBMS Server » Security » windows Authentication
windows Authentication [message #14557] Tue, 31 August 2004 05:57 Go to next message
Richard
Messages: 44
Registered: May 2000
Member
 

I like to give windows authentication to oracle database user on the oracle server(Oracle9.2) itself.

I did the following steps:

1) created a user richard with ora_dba and Admin privilege.

2) create a database user using the following sqlstatement

 "create user ops$richard identified externally"

3) given connect privilege to the user

4) I have logged on the system as richard

5) from command prompt i typed sqlplus/

but iam getting the following error messages

-------------------------------------------------------------------
C:Documents and Settingsrichard>sqlplus/

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Aug 31 19:11:39 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
----------------------------------------------------------------------

can anyone of you help me.

Regards,
Richard
Re: windows Authentication [message #14653 is a reply to message #14557] Thu, 02 September 2004 22:50 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Hi,

You should actually get an "ORA-01004: default username feature not supported; logon denied" error. Is your "os_authent_prefix" parameter is set to "OPS$"?

Best regards.

Frank
Previous Topic: Recovering the sys password
Next Topic: Oracle Security
Goto Forum:
  


Current Time: Tue Nov 30 11:58:30 CST 2021