Re: What's the default database administrator username in the Orcale 10g world?
Date: Fri, 7 Nov 2008 08:50:00 -0800 (PST)
Message-ID: <b100cb60-1328-487c-a8a0-bcae1b325a21@w39g2000prb.googlegroups.com>
On Nov 6, 4:56 pm, "Spin" <S..._at_invalid.com> wrote:
> Gurus,
>
> What's the default database administrator username in the Oracle 10g world?
> For MS SQL Server it is "SA". But someone told me for Oracle it was
> actually several names, including one called "SYS". Is that true?
>
> --
> Spin
Yes, the internal owner of the rdbms base tables is user SYS. Every user who connects as SYSDBA is user SYS. The user SYS should only be used to start and stop the database, run upgrades, recovery, and to apply Oracle provided packages and scripts that are designated to be ran by user SYS such as catalog, catproc, optional script cataudit.sql, and several of the utl_ scripts.
Oracle also provides the user SYSTEM plus several special purpose usernames like SYSMAN for the EM Admin, DBSNMP OEM agent, CTXSYS Oracle text owner, etc ....
The usernames Oracle provides are documented in the manuals.
HTH -- Mark D Powell -- Received on Fri Nov 07 2008 - 10:50:00 CST