Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

System user and Sys User

Status
Not open for further replies.

teksadat

MIS
Jul 10, 2003
29
US
Can anyone tell me the use of System user. why it is created and when should we use it.

Thanks in advance.
 
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:



Hope this helps

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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top