System user and Sys User

[teksadat]

Can anyone tell me the use of System user. why it is created and when should we use it.

Thanks in advance.

 

[Dubi123]

I have put your query into Google and got following explanation:

SYS
SYS is the owner of the database and the owner of the data dictionary. Never ever create objects under SYS. The objects belonging to SYS cannot be exported.

SYSTEM
SYSTEM is a privileged administration user, and typically owns Oracle provided tables other than

Personaly, when I write script for startup/shutdown of iAS database I use SYS:

connect SYS/<password> as SYSDBA

then start or shutdwon and quit.

Here is a link:

http://www.adp-gmbh.ch/ora/misc/sys_system_internal.html

Hope this helps

Dubravko

 

[teksadat]

Thank you Dubravko,

Even i have tried looking it in Google but at the best i too got the same result. so though of putting it in my favorite forum, hope someone will have something else better than this.

Thank you once again for your interest in answering to my query.

 

[BJCooperIT]

For a more thorough explanation, try posting in the Oracle: Oracle release - 9i or 10g forums. There are several MVPs there, who do not frequent this forum, who can give you a good answer.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus