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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Difference between SYS and SYSDBA 2
- Thread starter Jupbs
- Start date
-
2
- #2
sybaseguru
Instructor
Jupbs,
This is a frequently asked questions. When an Oracle database is created say via Database Configuration Assistant DBCA tool, two accounts are always created. These are "sys" and "system" (not to be confused with sysdba). The "sys" user is the most powerfull users in the database . It owns all the of the internal objects that make up the database. In addition there is another account called "system" from which you as a dba do most of your object creation.
Now "SYSDBA" is NOT a user in Oracle database but a role. To connect to database as the most powerful user you need to connect as user "sys" with the phrase "as sysdba", or Oracle will issue an error message and not let you connect.
So you do
In this case you are connecting as user sys as the database administrator. You cannot connect as "sys" user without issuing the phrase "as sysdba". There are no restrictions on what a user with SYSDBA can do in the database.
I hope this helps
This is a frequently asked questions. When an Oracle database is created say via Database Configuration Assistant DBCA tool, two accounts are always created. These are "sys" and "system" (not to be confused with sysdba). The "sys" user is the most powerfull users in the database . It owns all the of the internal objects that make up the database. In addition there is another account called "system" from which you as a dba do most of your object creation.
Now "SYSDBA" is NOT a user in Oracle database but a role. To connect to database as the most powerful user you need to connect as user "sys" with the phrase "as sysdba", or Oracle will issue an error message and not let you connect.
So you do
Code:
sqlplus "sys/xxxx@connect as sysdba"In this case you are connecting as user sys as the database administrator. You cannot connect as "sys" user without issuing the phrase "as sysdba". There are no restrictions on what a user with SYSDBA can do in the database.
I hope this helps
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question