Home » RDBMS Server » Server Administration » Urgent help - Windows authentication for Oracle
Urgent help - Windows authentication for Oracle [message #62996] Tue, 31 August 2004 06:07 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) system 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: Urgent help - Windows authentication for Oracle [message #62997 is a reply to message #62996] Tue, 31 August 2004 06:51 Go to previous message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
HI

set parameter value in init parameter file

" os_authent_prifix = 'ops$'"

it will work but u need to shutdown the database to this operation

Regards
D.Dilip
Previous Topic: import/export
Next Topic: Oracle 10g installation
Goto Forum:
  


Current Time: Fri Sep 27 08:28:48 CDT 2024