SYSDBA和SYSOPER的區別

显示全部楼层 · 2005-6-22 01:01:25

謝謝

千问 · 2005-6-22 01:01:25

*SYSDBA
Much like UNIX's root account. The account basically
can do anything including destroying the database.
*SYSOPER
Simply a bit less privilaged account than SYSDBA.
sysoper: startup,shutdown,alter database open|mount,alter database backup controlfile,
　　 alter tablespace begin/end backup,recover database
　　 alter database archivelog,restricted session
sysdba: sysoper privileges with admin option,create database,recover database until

千问 · 2005-6-22 01:01:25

The database uses password files to keep track of database usernames who have been granted the SYSDBA and SYSOPER privileges. These privileges allow database administrators to perform the following actions.
SYSOPER Permits you to perform STARTUP, SHUTDOWN, ALTER DATABASE OPEN/MOUNT, ALTER DATABASE BACKUP, ARCHIVE LOG, and RECOVER, and includes the RESTRICTED SESSION privilege.
SYSDBA Contains all system privileges with ADMIN OPTION, and the SYSOPER system privilege; permits CREATE DATABASE and time-based recovery.

千问 · 2005-6-22 01:01:25

謝謝

千问 · 2005-6-22 01:01:25

谢谢各位楼上，又长了些知识。