REPOST: Re: INTERNAL, SYS, SYSTEM system users

On Sat, 29 Dec 2001 20:11:39 +0100, "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote:

>"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message
>news:kOmW7.61$GN5.3686_at_inet-nntp1.oracle.com...
>> One minor correction from a terminology perspective. INTERNAL was
>> deprecated in Oracle8 and is gone entirely in Oracle9. "Deprecated"
>is
>> Oracle-speak for "we're going to get rid of this soon".
>
>Does it mean that Oracle also concluded that there's confusion for many
>people and there's no need for existence of INTERNAL account?
>
>Is INTERNAL only "internal" reference on SYS acc because when one change
>password of SYS, this automatically becomes new password for INTERNAL
>acc?

the SYS password is checked against the datadictionary, the INTERNAL user is not checked against the dictionary. It is a means to access the database when the database is down. You will mainly use internal for maintenance purposes, during maintenance the database can't be up, so the SYS password can't be checked.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

• WAS CANCELLED BY =======: Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: Sybrand Bakker <oradba_at_sybrandb.demon.nl> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <e3cs2uk72r35hn43a57rj93giuu8f06u4m_at_4ax.com> Control: cancel <e3cs2uk72r35hn43a57rj93giuu8f06u4m_at_4ax.com> Date: Mon, 31 Dec 2001 05:04:47 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.e3cs2uk72r35hn43a57rj93giuu8f06u4m_at_4ax.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788887 26548 166.102.15.34 (31 Dec 2001 08:54:47 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:54:47 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Sat Dec 29 2001 - 15:09:20 CST