Administrative Privileges (31)

最新推荐文章于 2024-02-07 15:51:42 发布

转载最新推荐文章于 2024-02-07 15:51:42 发布 · 988 阅读

文章标签：

#开发工具 #数据库

本文介绍数据库管理员所需的两种特殊系统权限：SYSDBA和SYSOPER。这两种权限允许管理员即使在数据库未打开的情况下也能访问数据库实例。SYSDBA权限允许进行完全的数据库管理操作，而SYSOPER则提供较有限的操作权限。

Administrative privileges that are required for an administrator to perform basic
database operations are granted through two special system privileges, SYSDBA and
SYSOPER. You must have one of these privileges granted to you, depending upon the
level of authorization you require.

Note: The SYSDBA and SYSOPER system privileges allow access
to a database instance even when the database is not open. Control
of these privileges is totally outside of the database itself.
The SYSDBA and SYSOPER privileges can also be thought of as
types of connections that enable you to perform certain database
operations for which privileges cannot be granted in any other
fashion. For example, you if you have the SYSDBA privilege, you
can connect to the database by specifying CONNECT AS SYSDBA.

管理员权限
1. 被赋予两个特殊的系统权限 , sysdba 与 sysoper
这两个权限在数据库未被打开的情况下 , 也能够登入实例

[@more@]

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

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