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

Report message to a moderator

- Re: windows Authentication [message #14653 is a reply to message #14557] Thu, 02 September 2004 22:50 Go to previous message
Frank Naude
Messages: 4596
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 04 06:41:45 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.