Oracle user types

(1) Multiple Oralce databases can be installed on one computer.

(Instance), their SID cannot be the same

(2) You can install multiple identical

SID Oracle Database (Instance)

(3) In the same network

The global database name must not be the same

(4) Global Database naming:

SID. domain name (family name, family owner name)

(Name of a child in a family)

(5) SYS user

SYS is a Super User in Oracle. It is mainly used to maintain system information and manage instances. All Tables and views of data dictionaries in the database are stored in SYS mode.

SYSTEM User

The SYSTEM user is the default Administrator in Oracle and has the DBA permission. This user has internal tables and views used by the Oracle management tool. Generally, the SYSTEM user manages the users, permissions, and storage of the Oracle database.

SCOTT user

SCOTT is a demo account of the Oracle database.