Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Internal Password

RE: Internal Password

From: Burton, Laura L. <BurtonL_at_prismplus.com>
Date: Thu, 08 Aug 2002 14:12:05 -0800
Message-ID: <F001.004AFEBF.20020808141205@fatcity.com>


Thanks for your response Kevin. We use NT. I can sign on without using a password as well, but I do not want to be able to. Today I did found that commenting out an entry in the SqlNet.ora file will force the need for a password and this is how I resolved the problem.  

Thanks,
Laura  

-----Original Message-----
Sent: Thursday, August 08, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L  

What OS and version of Oracle are you using? On unix systems, the presumption is that only authorized personnel (DBAs and Sys Admins) can connect as the oracle user. Only the oracle user can connect internal. If unauthorized personnel have the oracle password, change it immediately to something obscene that includes special characters -- if it's properly obscene, you won't be tempted to write it down on a yellow sticky attached to your screen 8-)  

If you are on NT, this is somewhat but not significantly different (if I remember right, it's been a few years since I've done Oracle on NT). An Oracle server on NT should not allow logins by anyone except the DBA and NT administrator who should both be trusted.  

By the way, I use remote_login_passwordfile=exclusive on unix and connect internal works just fine without a password. Maybe the shared setting works differently and maybe this works differently between unix and NT. Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What can this mean? -----Original Message-----
Sent: Wednesday, August 07, 2002 10:23 PM To: Multiple recipients of list ORACLE-L I can sign on as Internal and not key in a password. I have tried to 'edit' the password as well as 'delete' the sid and make a 'new' sid with an internal password, but I can still access the database as internal without having to input a password.
Could someone shed some light on how to correct this. Thank you in advance,
Laura

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Burton, Laura L.
  INET: BurtonL_at_prismplus.com

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: ListGuru_at_fatcity.com (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). Received on Thu Aug 08 2002 - 17:12:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US