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/
________________________________________________________________________
Oracle LazyDBA home page