Note 60634.1 O/S Authentications on NT (Secure and Non-Secure)
Your problem is probably because of Domain Prefixing. You should create the
user with a domain name (see note).
Other notes you can use:
Note: 274115.1 Quick Checklists for User Authentication
Note 132786.1 Win: ORA-01017 When Using OPS$ Authentication
HTH
Ofer
-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x47979990.[Email address protected]
Sent: Monday, April 03, 2006 12:04 PM
To: LazyDBA Discussion
Subject: Windows Authentication
I am still experiencing problems creating an SQL account which is
authenticated
externally and if anybody can solve this problem I would be grateful as it
has
fried my brain for nearly a week !!!!
Here's what I have tried so far and some of it might not have been necessary
but if I explain the full picture hopefully it will help !
1) The database I am experimenting with is on my PC and the ORACLE_SID=BRETT
2) My network userid is: EXTONBN
3) I added two new entries to my INIT.ora
os_authent_prefix=''
REMOTE_OS_AUTHENT=FALSE
4) In my SQLNET.ora I ensured I had an entry:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
5) I added EXTONBN to the group ORA_DBA
6) I stop / started the database
7) Via the "system" account I created an SQLPLUS userid for myself via:
create user extonbn identified externally;
grant create session to extonbn;
8) Via a "cmd" prompt I typed
SET ORACLE_SID=BRETT
sqlplus /*BRETT (where the asterisk is an "at" symbol)
but got:
ERROR:
ORA-01017: invalid username/password; logon denied
7) If I then login as system and change my userid:
alter user extonbn identified by brett;
I can login successfully using extonbn/brett
=======================
I'm not sure if this is relevant but will mention it just incase. My network
password contains a fullstop at the end. for example: "mypword12."
If I try to manually set a password with a fullstop in it then it generates
an
error e.g:
alter user extonbn identified by mypword12.
ERROR at line 1:
ORA-00922: missing or invalid option
So does this mean Oracle doesn't like special characters in passwords ?
--
Brett Exton
________________________________________________________________________
This e-mail and any attachments transmitted with it represents the
views of the individual(s) who sent them and should not be regarded
as the official view of Bridgend County Borough Council. The contents
are confidential and intended solely for the use of the addressee. If
you have received it in error, please inform the system administrator
on (+44) 01656 642111.
This e-mail and any attachments have been scanned with 'MessageLabs SkyScan'
- http://www.messagelabs.com/
________________________________________________________________________
Maer'r e-bost hwn ac unrhyw atodiadau a drosglwddir gydag ef yn cynrychioli
safbwyntiau'r unigolyn (unigolion) a'u hanfonodd ac ni ddylid eu hystyried
fel
safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r
cynnwy
syn gyfrinachol ac wedi'i fwriadu at ddefnydd y person y'i cyfeiriwyd ato yn
unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwry
system ar (+44) 01656 642111.
Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda 'MessageLabs
SkyScan' - http://www.messagelabs.com/
________________________________________________________________________
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**********************************************************************
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of
Barak I.T.C (1995) The International Telecommunications Services Corp. Ltd.
**********************************************************************
Oracle LazyDBA home page