视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
oracle官方文档之PredefinedUserAccounts
2020-11-09 07:36:04 责编:小采
文档


搜索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

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 theSYSMAN 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 SYSTEMSYSMAN 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, andDBSNMP)

    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 theDBSNMP 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 areHR, 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
    11g 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
    11g 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

    下载本文
    显示全文
    专题