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

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 - Production on Tue Aug 31 19:11:39 2004

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

ORA-01017: invalid username/password; logon denied

Enter user-name:

can anyone of you help me.

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

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.

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

Current Time: Mon Aug 15 08:32:42 CDT 2022