dbTalk Databases Forums  

What's the default database administrator username in the Orcale 10g world?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss What's the default database administrator username in the Orcale 10g world? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Spin
 
Posts: n/a

Default What's the default database administrator username in the Orcale 10g world? - 11-06-2008 , 03:56 PM






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



Reply With Quote
  #2  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale 10g world? - 11-06-2008 , 04:11 PM






On Thu, 6 Nov 2008 16:56:22 -0500, "Spin" <Spin (AT) invalid (DOT) com> wrote:

Quote:
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?
Please read the 2 Day DBA manual online at http://tahiti.orale.com

The Oracle architecture is 100 percent from world most known toy
database sqlserver.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #3  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale 10g world? - 11-06-2008 , 04:11 PM



On Thu, 6 Nov 2008 16:56:22 -0500, "Spin" <Spin (AT) invalid (DOT) com> wrote:

Quote:
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?
Please read the 2 Day DBA manual online at http://tahiti.orale.com

The Oracle architecture is 100 percent from world most known toy
database sqlserver.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #4  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale 10g world? - 11-06-2008 , 04:11 PM



On Thu, 6 Nov 2008 16:56:22 -0500, "Spin" <Spin (AT) invalid (DOT) com> wrote:

Quote:
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?
Please read the 2 Day DBA manual online at http://tahiti.orale.com

The Oracle architecture is 100 percent from world most known toy
database sqlserver.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #5  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale 10g world? - 11-06-2008 , 04:11 PM



On Thu, 6 Nov 2008 16:56:22 -0500, "Spin" <Spin (AT) invalid (DOT) com> wrote:

Quote:
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?
Please read the 2 Day DBA manual online at http://tahiti.orale.com

The Oracle architecture is 100 percent from world most known toy
database sqlserver.

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #6  
Old   
Mark D Powell
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale10g world? - 11-07-2008 , 10:50 AM



On Nov 6, 4:56*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
Quote:
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 --


Reply With Quote
  #7  
Old   
Mark D Powell
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale10g world? - 11-07-2008 , 10:50 AM



On Nov 6, 4:56*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
Quote:
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 --


Reply With Quote
  #8  
Old   
Mark D Powell
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale10g world? - 11-07-2008 , 10:50 AM



On Nov 6, 4:56*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
Quote:
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 --


Reply With Quote
  #9  
Old   
Mark D Powell
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale10g world? - 11-07-2008 , 10:50 AM



On Nov 6, 4:56*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
Quote:
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 --


Reply With Quote
  #10  
Old   
Spin
 
Posts: n/a

Default Re: What's the default database administrator username in the Orcale 10g world? - 11-07-2008 , 05:41 PM



Thanks!!!!!!!!!!!!!!!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.