<div>
SYS and SYSTEM users are created by Oracle when creating a database. &nbsp;The schema SYS basically owns all the dictionary objects.<br />
<br />
SYSDBA and SYSOPER are keywords used in the connect statement. &nbsp; These map to OS groups osdba and osoper. &nbsp;If your OS account is in these groups you can connect using SYSDBA/SYSOPER such as:<br />
<br />
connect / as sysdba;<br />
<br />
connect / as sysoper;<br />
<br />
You then get appropriate privileges associated with SYSDBA/SYSOPER.
</div>


SYS and SYSTEM users are created by Oracle when creating a database.  The schema SYS basically owns all the dictionary objects.

SYSDBA and SYSOPER are keywords used in the connect statement.   These map to OS groups osdba and osoper.  If your OS account is in these groups you can connect using SYSDBA/SYSOPER such as:

connect / as sysdba;

connect / as sysoper;

You then get appropriate privileges associated with SYSDBA/SYSOPER.

<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
<br />
I need some information about the sys and system users. What's the difference between them, and what are the options as sysdba, sysoper and normal. What do these influence?<br />
Can I create a user, that is sysdba?<br />
<br />
Thanx, thrash
</div>
</div>


Hi Experts, 

I need some information about the sys and system users. What's the difference between them, and what are the options as sysdba, sysoper and normal. What do these influence?
Can I create a user, that is sysdba?

Thanx, thrash

Oracle: sys vs. system

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.