INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Just to let you know...what a great site you have. I posted a pretty generic question yesterday and have had 8 responses already, anyway thanks again and keep up the good work..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > MIS/IT > e-Business > Oracle: Oracle9iAS Application Server Forum

System user and Sys User

Read More Threads Like This One

teksadat (MIS)

24 Jul 06 9:51

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

Thanks in advance.

Dubi123 (Programmer)

26 Jul 06 8:19

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 (MIS)

27 Jul 06 12:02

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 (Programmer)

27 Jul 06 12:47

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.

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Oracle: Oracle9iAS Application Server