PredefinedUserAccounts in oracle official documentation

Search for oracle11.2 official documents: mgmt_userdocs.oracle.comcdE11882_01network.112e36292authorization.htm # workshop. Search for oracle11.2 official documents: SYSMAN

Search oracle 11.2 official documentation: 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. Search oracle 11.2 official documentation: SYSMAN

Search for the official oracle 11.2 document: mgmt_user

Http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG99887

MGMT_USER

GrantsSELECTPrivilege on the different views used forSYSMANSchema.

Search official oracle 11.2 documents: 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 performOracle Enterprise ManagerDatabase administration tasks. (perform database management tasks for oem components)

Oracle Enterprise Manager Grid Control Basic Installation Guide

Note:
The predefined users in the oracle database, oracle company designed the oracle database software to classify these predefined users and different users perform different tasks. For different users to execute different tasks, this is not a technical (Design) problem, but a business logic design problem. The user SYSMAN created when oracle database software was designed is used to execute database management tasks for oem components. One of SYSMAN's roles isMGMT_USER.
In short, oracle has designed oracle database software for different predefined database users for different purposes. Once a pre-defined database user is specified for a specific purpose, the specific permissions of the (pre-defined) database user will be assigned according to the needs of this purpose. Instead of having some permissions for some purpose. Who, because of whom, should not be reversed, in terms of Logical Understanding.

Predefined User Accounts

Predefined User Accounts Oracle Database includes several predefined user accounts. The three types of predefined accounts are: Administrative accounts (SYS SYSTEMSYSMANAnd 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 partitions des several predefined user accounts. The three types of predefined accounts are:

• Administrative accounts (SYS,SYSTEM,SYSMAN, AndDBSNMP)

  SYSAndSYSTEMAre described in "About Database Administrator Security and Privileges ".SYSMANIs used to perform Oracle Enterprise Manager administration tasks. The management agent of Enterprise Manager usesDBSNMPAccount 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, AndOE. You must unlock these accounts and reset their passwords before using them.

• Internal accounts.

  These accounts are created so that inpidual 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.

Refer:

Oracle? Database Administrator's Guide 11GRelease 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 11GRelease 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