Oracle Database: Administrative Accounts — SYS, SYSTEM, DBA

goay xuan hui
1 min readJul 12, 2021

About Roles

Roles are groupings of privileges that you can use to create different levels of database access.

About Administrative Accounts

By default, when Oracle Database is installed, the following administrative accounts are automatically created:

  • SYS (Granted the DBA role)

Under the schema of SYS user, all base tables and views for the database data dictionary are stored, which are critical for the operation of Oracle database.

Ensure that most database users are never able to connect to Oracle Database with the SYS account.

  • SYSTEM (Granted the DBA role)

The SYSTEM user can create additional tables and views that display administrative information as well as internal tables and views.

DBA Role

If you have got a database, we need to have someone who knows how to run it. This is where Oracle Database Administrators (DBA) come in.

This role contains most database system privileges so it should be only granted to actual database administrators.

The DBA, however, does not include the SYSDBA or SYSOPER system privileges. The SYSDBA and SYSOPER are administrative privileges required to perform basic database operations such as creating the database and instance startup and shutdown.

What does an Oracle DBA do? | Career Insights (freelancermap.com)

--

--

goay xuan hui

A food lover, a cyber security enthusiast, a musician and a traveller, so you will see a mix of different contents in my blog. ☺️