搜索oracle 11.2官方文档:mgmt_user http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG99887 MGMT_USER Grants the SELECT privilege on the different views used for the SYSMAN schema. 搜索oracle 11.2官方文档:SYSMAN
搜索oracle 11.2官方文档:mgmt_user
MGMT_USER
Grants the SELECT privilege on the different views used for the SYSMAN schema.
搜索oracle 11.2官方文档:SYSMAN
SYSMAN
The account used to perform Oracle Enterprise Manager database administration tasks. Oracle Enterprise Manager Grid Control Basic Installation Guide
Database Installation Guide for Microsoft Windows ? Search this book ? Hide this book ? Contents ? PDF
SYSMAN
The account used to perform Oracle Enterprise Manager database administration tasks.(执行 oem组件的数据库管理任务)
Oracle Enterprise Manager Grid Control Basic Installation Guide
注释:
oracle数据库里这些预定义的用户,oracle公司设计oracle数据库软件时就已经将这些预定义的用户分类,不同用户执行不同任务。而让不同用户执行不同任务,这个问题不是一个技术(设计)问题,而是一个业务逻辑设计问题。当初设计oracle数据库软件时创建的用户 SYSMAN 就是用于 执行 oem组件的数据库管理任务 的。 SYSMAN 的角色之一为 MGMT_USER 。
总之,不同预定义数据库用户,oracle公司设计oracle数据库软件时就已经将它们分类规定用于不同用途, 这是人为规定的。一旦规定了某一个预定义数据库用户用于某种用途,就会根据这个用途的需要分配该(预定义)数据库用户特定的权限。而不是因为有了某种权限,而有了某种用途。谁因谁果不要颠倒,在逻辑理解上。
Predefined User Accounts
Predefined User Accounts Oracle Database includes several predefined user accounts. The three types of predefined accounts are: Administrative accounts ( SYS SYSTEM SYSMAN and DBSNMP ) SYS and SYSTEM are described in "About Database Administrator
Administrator's Guide ? Search this book ? Hide this book ? Contents ? PDF
Predefined User Accounts
Oracle Database includes several predefined user accounts. The three types of predefined accounts are:
Administrative accounts ( SYS , SYSTEM , SYSMAN , and DBSNMP )
SYS and SYSTEM are described in "About Database Administrator Security and Privileges". SYSMAN is used to perform Oracle Enterprise Manager administration tasks. The management agent of Enterprise Manager uses the DBSNMP account to monitor and manage the database. You must not delete these accounts.
Sample schema accounts
These accounts are used for examples in Oracle Database documentation and instructional materials. Examples are HR , SH , and OE . You must unlock these accounts and reset their passwords before using them.
Internal accounts.
These accounts are created so that individual Oracle Database features or components can have their own schemas. You must not delete internal accounts, and you must not attempt to log in with them.
See Also:
Oracle Database 2 Day + Security Guide for a table of predefined accounts.
参考:
Oracle? Database Administrator's Guide
11 g Release 2 (11.2)
E25494-05
Home
Book List
Contents
Index
Master Index
Contact Us
Previous
Next PDF ·Mobi · ePub
7 Managing Users and Securing the Database
Oracle? Database 2 Day + Security Guide
11 g Release 2 (11.2)
E10575-09
Home
Book List
Contents
Index
Master Index
Contact Us
Previous
Next PDF ·Mobi · ePub
3 Securing Oracle Database User Accounts
查看更多关于oracle官方文档之PredefinedUserAccounts的详细内容...