must be uppercase !!
Create user "DOMAIN\EXTONBN" identified externally;
also you must declare os_authent_prefix=''"
with double quoted
Ofer
-----Original Message-----
From: Keith Williams [mailto:oracledba-ezmlmshield-x67911431.[Email address protected]
Sent: Monday, April 03, 2006 4:23 PM
To: LazyDBA Discussion
Subject: RE: Windows Authentication
Your user account in windows includes the domain name. So youy userid
is actually domain\user. To make it more difficult, the backslash is not
normally a valid character in a SQL identifier, so the Oracle username
must be double-quoted:
Create user "domain\extonbn" identified externally;
Keith
-----Original Message-----
From: Brett N Exton
[mailto:oracledba-ezmlmshield-x47979990.[Email address protected]
Sent: Monday, April 03, 2006 5:04 AM
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
IMPORTANT NOTICE:
This message may contain confidential information. If you have received this e-mail in error, do not use, copy or distribute it. Do not open any attachments. Delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
--------
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