sysdba和sysoper两个特权用户的区别

最新推荐文章于 2021-04-13 15:50:04 发布

Linucle

最新推荐文章于 2021-04-13 15:50:04 发布

阅读量1.0k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/linucle/article/details/9447459

版权

12 篇文章 0 订阅

订阅专栏

本文探讨了在数据库管理系统中，SYSDBA和SYSOPER两种超级权限的区别。SYSDBA提供全面的数据库管理员权限，而SYSOPER则允许进行特定的系统操作，如启动和关闭数据库实例。

摘要由CSDN通过智能技术生成

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

System Privilege Operations Authorized

System Privilege	Operations Authorized
`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 `CREATE SPFILE` `ALTER DATABASE OPEN/MOUNT/BACKUP` `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. sysoper不能查看其他用户的信息，For `SYSDBA` this schema is `SYS`; for `SYSOPER` the schema is `PUBLIC`.

SYSDBA

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
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.

sysoper不能查看其他用户的信息，For SYSDBA this schema is SYS; for SYSOPER the schema is PUBLIC.

关注

专栏目录