authentication externally on WinNT
It's working now! Thanks to all that helped. In addition, I discovered that you must put one parameter in sqlnet.ora file: SQLNET.AUTENTICATION_SERVICES=(NTS) Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: authentication externally on WinNT
I was just recently playing around with this and found a couple of tips to fix my problem: There is a registry setting called: OSAUTH_PREFIX_DOMAIN that is now defaulted to TRUE for 8.1 databases. To get my machine to login without a username/password I had to create an oracle user name like "MYDOMAIN\USERABC". ( not sure if it matters but the notes also said to put everything in uppercase). You can set this to false and then i believe the domain name can be left off the oracle username. There is an init.ora parameter = REMOTE_OS_AUTHENT that must be set to TRUE ( I do believe this causes some security risks so you may want to investigate those issues to.) There is also an init.ora parameter OS_AUTHENT_PREFIX that needs to be set. I believe the default is now "" (no prefix required for the oracle user account). I used these keywords and was able to locate some helpful documents in Metalink. HTH, Jim References Metalink: Note:102665.1 -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wednesday, April 18, 2001 2:28 AM >Hi! > >Oracle8.1.7 on WinNT. >I created database user with external authentication with whom I'm logged on >that WinNT server. >When I start exp there is error > invalid username/password logon denied. >What am I missing? It works just fine on UNIX! > >TIA, >Sonja >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: authentication externally on WinNT
Are you suggesting using "ops$" accounts over sql*net?. Is your database inaccessible usesr with administrator/root privileges on any of their machines? OPS$ authentication is notoriously easy to spoof. Ian MacGregor Stanford Linear Accelerator Center ian@slac,stanford.edu -Original Message- Sent: Wednesday, April 18, 2001 9:46 AM To: Multiple recipients of list ORACLE-L You need an oracle username with authent_prefix added to the NT username, which means that if NT username is "scott", oracle username should be "ops$scott", in case that you will be using the default authentication prefix of "ops$". You can always choose something else, like 'mg$', (my initials, combined with my favorite currency) -Original Message- Sent: Wednesday, April 18, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi! Oracle8.1.7 on WinNT. I created database user with external authentication with whom I'm logged on that WinNT server. When I start exp there is error invalid username/password logon denied. What am I missing? It works just fine on UNIX! TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: authentication externally on WinNT
You need an oracle username with authent_prefix added to the NT username, which means that if NT username is "scott", oracle username should be "ops$scott", in case that you will be using the default authentication prefix of "ops$". You can always choose something else, like 'mg$', (my initials, combined with my favorite currency) -Original Message- Sent: Wednesday, April 18, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi! Oracle8.1.7 on WinNT. I created database user with external authentication with whom I'm logged on that WinNT server. When I start exp there is error invalid username/password logon denied. What am I missing? It works just fine on UNIX! TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
authentication externally on WinNT
Hi! Oracle8.1.7 on WinNT. I created database user with external authentication with whom I'm logged on that WinNT server. When I start exp there is error invalid username/password logon denied. What am I missing? It works just fine on UNIX! TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
