Shulou(Shulou.com)06/01 Report--

There are two types of Oracle accounts:

Required accounts, such as SYS/SYSTEM/SYSMAN, etc.

Accounts that store various applications

The user password describes the account that ANONYMOUSANONYMOUS uses to access the ORACLEXMLDB knowledge base. CTXSYSCTXSYSinterMedia Text user, account with CONNECT\ RESOURCE\ DBA permissions for DIPDIP directory integration platform (DIRECTORYINTEGERATIONPLATFORM) DBSNMPDBSNMP directory integration platform user, DBSNMP includes the CONNECT,RESOURCEHE SNMPAGENT database role.

Create script:? / rdbms/admin/catsnmp.SQL, called from catalog.SQL

You can change your password-you need to place a new password in the snmp_rw.ora file

If you do not need Intelligent agents, you can delete the user. DMSYSDMSYS

EXFSYSEXFSYS expression filter account (EXPRESSIOFILTER) MDDATAMDDATAORACLE Spatial data account MDSYSMDSYS Spatial data (SPATIAL)\ Media (INTERMEDIA)\ Audio (AUDIO)\ Video (VIDEO) and Image Administrator account. It has CONNECT and RESOURCE roles. MGMT_VIEWMGMT_VIEWMGMT_VIEW users are part of DB Control Repository, and together with SYSMAN users form part of DB Control Repository.

MGMT_VIEW does not own any objects and is only used to query the users of the SYSMAN user object OLAPSYSMANAGER used to create OLAP metadata. Includes user names of OLAP_DBA\ RESOURCE\ CONNECT roles ORDPLUGINSORDPLUGINSORACLE INTERMEDIA and VIDEO, CONNECT and RESURCE roles, user names of ORDSYSORDSYSORACLEINTERMEDIA and VIDEO to connect with third parties, CONNECT and RESOURCE roles OUTLNOUTLN, CONNECT and RESOURCE roles SCOTTTiger simple sample account SI_INFORMTN_SCHEMA

Still image standard browsing account SYS installation determines to perform database management tasks, instance data dictionaries are determined to perform database management tasks under SYS SYSMANOEM_TEMP enterprise manager account SYSTEM installation, there are a small number of instance objects WK_TESTWK_TEXT management ORACLE10gULTRASEARCH account, and WKSYS has the same role WKPROXY unknown ORACLE10g account related to the proxy server WKSYSWKSYS management ORACLE10gASULTRASEARCH account Same function as WK_TEST WMSYSWMSYS Workspace Management account XDBCHANGE_ON_INSTALLXMLDB account TSMSYS

The new features of all catalogs of Oracle 10g and related viewpoints / tables are stored in oracle_ocm under TSMSYS users.

Oracle predefined non-administrator user FLOWS_FILES

Is the system account of Oracle Application Express, which has files uploaded by oracle application express. Appqossys

Used for storing/managing all data and metadata required by Oracle Quality of Service Management.apex030200

APEX product database users, in which ORACLE's information lifecycle management tool ILMA is used on the premise of Apex. Owbsys_audit

This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in the OWBSYS schema.orddata

This account contains the Oracle Multimedia DICOM data model.OWBSYS

The account for administrating the Oracle Warehouse Builder repository. Access this account during the installation process to define the base language of the repository and to define Warehouse Builder workspaces and users. A data warehouse is a relational or multidimensional database that is designed for query and analysis.XS$NULL

An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULLBI

The account that owns the Business Intelligence schema included in the Oracle Sample Schemas.PM

The account that owns the Product Media schema included in the Oracle Sample Schemas.IX

The account that owns the Information Transport schema included in the Oracle Sample Schemas.sh

Experimental and test users, including sample tables products, sales, customers, etc.

The password can be changed, the user can be deleted, and it is recommended to delete or lock OE in the product environment.

Sample user HR

Experimental and test users with sample tables empLoyees and departmentsSPATIAL_CSW_ADMIN_USR

The Catalog Services for the Web (CSW) account. It is used by the Oracle Spatial CSW cache manager to load all record type metadata, and record instances from the database into the main memory for the record types that are cached. See also SPATIAL_WFS_ADMIN_USR, MDDATA and MDSYS.SPATIAL_WFS_ADMIN_USR

The Web Feature Service (WFS) account. It is used by the Oracle Spatial WFS cache manager to load all feature type metadata, and feature instances from the database into main memory for the feature types that are cached. See also SPATIAL_CSW_ADMIN_USR, MDDATA and MDSYS.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.