Oracle development: Normal, Sysdba,sysoper difference

Oracle divides users into two categories: "System" and "SYS"

• The "system" user can only log in to EM with normal status. (Can be regarded as a general member of the company)
• "SYS" User has "SYSDBA" (can be regarded as the CEO of the Company) or "Sysoper" permission (can be regarded as the company's operations director), Landing em can only use these two identities, not with normal.

The "Sysoper" permission (the company's operations supervisor), which is the database operator privilege, includes:

Open the database server to shut down the database server
Back Up Database recovery database
Log Archive Session Limit

"SYSDBA" permissions (as the company's CEO), which is database administrator rights, include:

Open the database server to shut down the database server
Back Up Database recovery database
Log Archive Session Limit
Management features to create a database

What's the difference between normal, SYSDBA, Sysoper?
Normal is a normal user

The other two, and you'll see what they have right now.

SYSDBA has the highest system privileges
Sysoper is mainly used to start, close the database, Sysoper login after the user is public
SYSDBA is sys after landing.

Sql> Conn/as Sysdba is connected. Sql> Grant Sysoper to test, authorization succeeded. Sql> Conn Test/test as Sysoper; connected. Sql> show Useruser is connected to "public" sql> Conn Test/test as SYSDBA. Sql> show Useruser for "SYS" sql>

Oracle development: Normal, Sysdba,sysoper difference