導(dǎo)讀:1建站知識SYS用戶具有DBA權(quán)限，并且擁有SYS模式，只能通過SYSDBA登陸數(shù)據(jù)庫。是Oracle數(shù)據(jù)庫中權(quán)限最高的帳號SYSTEM具有DBA權(quán)限。個業(yè)網(wǎng)站建設(shè)公司網(wǎng)站建設(shè)制作。

1. SYS用戶具有DBA權(quán)限，并且擁有SYS模式，只能通過SYSDBA登陸數(shù)據(jù)庫。是Oracle數(shù)據(jù)庫中權(quán)限最高的帳號 SYSTEM具有DBA權(quán)限。但沒有SYSDBA權(quán)限。平常一般用該帳號管理數(shù)據(jù)庫就可以了。 2. （1）sys -- sysdba system --sysoper （2）startup/shutdown/dba管理兩個都能做 （3）sys擁有數(shù)據(jù)字典(dictionay),或者說dictionay屬于sys schema （4）sysdba比sysoper多了一個create database的權(quán)限 3. SYSDBA Perform STARTUP and SHUTDOWN operations ALTER DATABASE: open, mount, back up, or change character set CREATE DATABASE CREATE網(wǎng)站推廣優(yōu)化seo SPFIseo網(wǎng)站關(guān)鍵詞優(yōu)化LE 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 operatio建設(shè)網(wǎng)站nal tasks, but without the ability to look at user data相關(guān)個業(yè)網(wǎng)站建設(shè)公司網(wǎng)站建設(shè)制作。

關(guān)鍵詞標(biāo)簽: 區(qū)別 小結(jié)