Thanks for the question, OP.
Asked: January 04, 2001 - 11:22 pm UTC
Last updated: January 04, 2001 - 11:22 pm UTC
Version: 8.1.6.0
Viewed 10K+ times! This question is 
You Asked
Dear Tom,
Hi again !
When we Install Orcale,by Default we get SYS and SYSTEM
as an account.
If I do not create my DBA account on this system,can
I administrate ORACLE compeletely through either of
these accounts ,If Yes,through which account I can
take a full control over the database.Is it SYSTEM
or SYS Account.
What is the difference between SYS,SYSTEM and Internal
Login's ?
Kindly answer.
Thanks & Regards
OP
and Tom said...
I would not use either of SYS or SYSTEM except when I was directed to by a specific installation procedure. You should create your own DBA accounts and grant them the sysdba or sysoper privelege to startup/shutdown the database.
SYS is special. But sys is not good enough. You need INTERNAL or SYSDBA to do certain operations. I would recommend strongly against using SYS to do things. SYS cannot create triggers, SYS cannot have read only transactions, and so on. SYS should not be used.
System is just an account, nothing special about it. We use it to store various things.
Internal is a super special account. It is a SYSDBA/SYSOPER. It can startup/shutdown the database. You should avoid using it as it will be going away at some point in the future. The correct approach is to "connect user/password AS sysdba" to perform these operations.
Is this answer out of date? If it is, please let us know via a Comment