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-----
From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 07, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
Subject: Internal PasswordI 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