sys是Oracle數(shù)據(jù)庫中權(quán)限最高的帳號(hào)，具有create database的權(quán)限，而system沒有這個(gè)權(quán)限，sys的角色是sysdba，system的角色是sysoper。

其余就是他們兩個(gè)用戶共有的權(quán)限了：

startup/shutdown/dba兩個(gè)用戶都是可以管理的。

平時(shí)用system來管理數(shù)據(jù)庫就可以了。這個(gè)用戶的權(quán)限對(duì)于普通的數(shù)據(jù)庫管理來說已經(jīng)足夠權(quán)限了。

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

Effectively, 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