Oracle Default User Rollup

Source: Internet
Author: User
Tags knowledge base

There are two types of Oracle accounts:

    1. Required accounts, such as Sys/system/sysman, etc.

    2. Store accounts for various applications;

User Password Description
ANONYMOUS ANONYMOUS The account used to access the ORACLEXMLDB knowledge Base.
Ctxsys Ctxsys Intermedia text user, with CONNECT\RESOURCE\DBA permissions
DIP DIP Account for the Directory Integration Platform (directoryintegerationplatform)
Dbsnmp Dbsnmp Directory Integration Platform user, DBSNMP includes connect,resourcehe snmpagent database roles.
Create script:?/rdbms/admin/catsnmp. SQL, called from catalog. Sql
Can change password--need to put new password to Snmp_rw.ora file
If you do not need intelligent agents, you can delete the user.
Dmsys Dmsys
Exfsys Exfsys Expression Filter account (Expressiofilter)
Mddata Mddata Oracle Spatial Data Account
Mdsys Mdsys Spatial data (spatial) \ Media (intermedia) \ Audio \ Video (videos) and image administrator accounts. It has connect and resource roles.
Mgmt_view Mgmt_view The Mgmt_view user is part of the DB control repository, and the Sysman user forms part of the DB control repository.
Mgmt_view does not own any objects and is only used to query Sysman user objects
Olapsys MANAGER The user who created the OLAP metadata. Include Olap_dba\resource\connect roles
Ordplugins Ordplugins User names for ORACLE intermedia and video, with Connect and resurce roles, with third-party connections
Ordsys Ordsys Username for Oracleintermedia and video, with connect and resource roles
Outln Outln Have connect and resource characters
SCOTT Tiger A simple sample Account
Si_informtn_schema
Still Image standard Browse account
SYS Determined at installation Perform the management task of the database, the data dictionary of the instance is under SYS
Sysman Oem_temp Enterprise Manager Account
SYSTEM Determined at installation Used to perform database administration tasks with a small number of instance objects
Wk_test Wk_text Manage Oracle10gultrasearch accounts, and Wksys have the same effect
Wkproxy Unknown oracle10g accounts related to the proxy server
Wksys Wksys Manage Oracle10gasultrasearch accounts with the same role as Wk_test
Wmsys Wmsys Workspace Management Account
XDB Change_on_install XMLDB Account
Tsmsys
The features of all Oracle 10g catalogs and the new features associated with this view/table are stored under Tsmsys users
oracle_ocm
Oracle pre-defined non-admin user
Flows_files
is an Oracle Application Express system account that 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 user, where Oracle's Information Lifecycle management tool, Ilma, is used as a prerequisite for apex.
Owbsys_audit
This account was 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 Warehous E Builder workspaces and users. A data warehouse is a relational or multidimensional database, 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$null
BI
The account is owns the business Intelligence schema included in the Oracle Sample Schemas.
Pm
The account is owns the Product Media schema included in the Oracle Sample Schemas.
Ix
The account this owns the information Transport schema included in the Oracle Sample Schemas.
Sh
Experiments, test users, including examples of products, sales, customers, etc.
Can modify the password, the user can be deleted in the product environment is recommended to remove or lock
Oe
Sample User
HR
Experiment, test user, sample table employees and departments
Spatial_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 Datab ASE into the main memory for the record types that is 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 data Base into main memory for the feature types is cached. See also Spatial_csw_admin_usr, Mddata and Mdsys.


This article is from the "DBA fighting!" blog, so be sure to keep this source http://hbxztc.blog.51cto.com/1587495/1878925

Oracle Default User Rollup

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.