Re:I learned something today...

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Fri, 08 Dec 2000 10:32:24 -0500
Message-Id: <10704.124028@fatcity.com>

FYI,
when you connect as internal, you are actually connecting as SYS with some = additional privileges. Thus, when you modify the SYS password, you are = also modifying the Internal (SYS) password.

>>> <dgoulet_at_vicr.com> 12/08/00 09:45AM >>>
Ron,

I've seen identical behavior on NT only. HP-UX and Linux work as per = the
docs. Blame MicroSlop.

Dick Goulet

____________________Reply Separator____________________
Author: "Ron Rogers" <RROGERS_at_galottery.org>
Date:       12/7/2000 7:26 PM

Group,
OS Novell , Oracle 7.3.4.0.1
  When I loaded the oracle on my server I used the ORAPWD command to set = the
INTERNAL password. The Oracle database was created and the users SYS and = SYSTEM
were automatically created with the default passwords. Using the SVRMGR = and
connect internal/password worked as designed with the created password. = Using
sys/default_password worked as designed when connecting to the database as = SYS.
I changed the SYS password and the INTERNAL password also changed.=20   My question is: how can internal and sys have different passwords in the beginning and then changing sys password also change the internal = password? It
seems that it is a security problem if both passwords are changed to be = the same
for internal and sys when you set them up as different passwords in the beginning. =20
  Reading the manual on the password utility states that the <password> parameter "is the initial password for INTERNAL, which is the equivalent = to the
password for user SYS". But it really isn't unless users SYS can have 2 passwords. <change_on_install> and the INTERNAL password.

I don't need to start a long discussion. I just wanted to point out that I = had a
point clarified to me today about 2 different passwords becoming 1.

ROR m*+*m

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org=20

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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--
Author:
  INET: dgoulet_at_vicr.com=20

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

Received on Fri Dec 08 2000 - 09:32:24 CST