| windows Authentication [message #14557] |
Tue, 31 August 2004 05:57  |
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  |
Frank Naude
Messages: 4579
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
