Urgent help - Windows authentication for Oracle [message #62996] |
Tue, 31 August 2004 06:07 |
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
|
|
|
|