The SYS user has the DBA permission and the SYS mode, and can only log on to the database through SYSDBA. The Account SYSTEM with the highest permissions in the Oracle database has the DBA permission. However, you do not have the SYSDBA permission. Generally, you can use this account to manage databases.
The SYS user has the DBA permission and the SYS mode, and can only log on to the database through SYSDBA. The Account SYSTEM with the highest permissions in the Oracle database has the DBA permission. However, you do not have the SYSDBA permission. Generally, you can use this account to manage databases.
1.
The SYS user has the DBA permission and the SYS mode, and can only log on to the database through SYSDBA. Is the account with the highest permissions in the Oracle database
SYSTEM has the DBA permission. However, you do not have the SYSDBA permission. Generally, you can use this account to manage databases.
2.
(1) sys -- sysdba
System -- sysoper
(2) startup/shutdown/dba management can both be done
(3) sys has a data dictionary (dictionay), or dictionay belongs to sys schema.
(4) sysdba has one more create database permission than sysoper.
3.
SYSDBA
Perform STARTUP and SHUTDOWN operations
Alter database: open, mount, back up, or change character set
CREATE DATABASE
CREATE SPFILE
ARCHIVELOG and RECOVERY
Includes the restricted session privilege
Specified tively, this system privilege allows a user to connect as user SYS.
SYSOPER
Perform STARTUP and SHUTDOWN operations
CREATE SPFILE
Alter database open/MOUNT/BACKUP
ARCHIVELOG and RECOVERY
Includes the restricted session privilege
This privilege allows a user to perform basic operational tasks, but without the ability to look at user data
