SYSDBA and SYSOPER (32)

最新推荐文章于 2025-12-15 21:10:21 发布

转载最新推荐文章于 2025-12-15 21:10:21 发布 · 63 阅读

文章标签：

本文介绍了Oracle数据库中SYSDBA和SYSOPER两种系统权限的区别。SYSDBA权限可以执行数据库启动、关闭、创建和删除等操作，并允许进行完整的数据库恢复；而SYSOPER权限则无法创建或删除数据库，在数据库恢复时仅支持完全恢复。

The following operations are authorized by the SYSDBA and SYSOPER system
privileges:

SYSDBA
■ Perform STARTUP and SHUTDOWN operations
■ ALTER DATABASE: open, mount, back up, or change character set
■ CREATE DATABASE
■ DROP DATABASE
■ CREATE SPFILE
■ ALTER DATABASE ARCHIVELOG
■ ALTER DATABASE RECOVER
■ Includes the RESTRICTED SESSION privilege
Effectively, this system privilege allows a user to connect as user SYS.

SYSOPER
■ Perform STARTUP and SHUTDOWN operations
■ ALTER DATABASE OPEN/MOUNT/BACKUP
■ CREATE SPFILE
■ ALTER DATABASE ARCHIVELOG
■ ALTER DATABASE RECOVER (Complete recovery only. Any form of incomplete recovery,
such as UNTIL TIME|CHANGE|CANCEL|CONTROLFILE requires connecting as SYSDBA.)
■ Includes the RESTRICTED SESSION privilege
This privilege allows a user to perform basic operational tasks, but
without the ability to look at user data.

The manner in which you are authorized to use these privileges depends upon the
method of authentication that you use.
When you connect with SYSDBA or SYSOPER privileges, you connect with a default
schema, not with the schema that is generally associated with your username. For
SYSDBA this schema is SYS; for SYSOPER the schema is PUBLIC.

sysdba与sysoper
1. sysoper与sysdba相比 , 不能创建,删除数据库 , 进行数据库恢复时只能使用完全恢复
2. 以sysdba连接 , 方案对象属于sys, 以sysoper连接,方案对象属于PUBLIC

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-994743/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-994743/