Oracle帳戶有兩種:
必須的帳戶,如SYS/SYSTEM/SYSMAN等
存儲各種應用的帳戶;
用戶 | 口令 | 說明 |
ANONYMOUS | ANONYMOUS | 用于訪問ORACLEXMLDB知識庫的帳戶。 |
CTXSYS | CTXSYS | interMedia Text用戶,有CONNECT\RESOURCE\DBA權限 |
DIP | DIP | 目錄集成平臺的帳戶(DIRECTORYINTEGERATIONPLATFORM) |
DBSNMP | DBSNMP | 目錄集成平臺用戶,DBSNMP包括CONNECT,RESOURCEHE SNMPAGENT數據庫角色。 創建腳本:?/rdbms/admin/catsnmp.SQL, called from catalog.SQL 可以改變密碼--需要放置新密碼到snmp_rw.ora文件 如果不需要Intelligent agents,可以刪除該用戶。 |
DMSYS | DMSYS | |
EXFSYS | EXFSYS | 表達式過濾器帳戶(EXPRESSIOFILTER) |
MDDATA | MDDATA | ORACLE空間數據帳戶 |
MDSYS | MDSYS | 空間數據(SPATIAL)\媒介(INTERMEDIA)\音頻(AUDIO)\視頻(VIDEO)和圖像管理員帳戶。它有CONNECT和RESOURCE角色。 |
MGMT_VIEW | MGMT_VIEW | MGMT_VIEW 用戶是DB Control Repository的一部分,和SYSMAN用戶一起構成DB Control Repository的組成部分。 MGMT_VIEW 不擁有任何對象,僅用于查詢 SYSMAN 用戶對象 |
OLAPSYS | MANAGER | 用于創建OLAP元數據的用戶。包括OLAP_DBA\RESOURCE\CONNECT角色 |
ORDPLUGINS | ORDPLUGINS | ORACLE INTERMEDIA和VIDEO的用戶名,有CONNECT和RESURCE角色,與第三方連接 |
ORDSYS | ORDSYS | ORACLEINTERMEDIA和VIDEO的用戶名,有CONNECT和RESOURCE角色 |
OUTLN | OUTLN | 有CONNECT和RESOURCE角色 |
SCOTT | Tiger | 簡單的樣例帳戶 |
SI_INFORMTN_SCHEMA | 靜止圖像標準瀏覽帳戶 | |
SYS | 安裝時確定 | 執行數據庫的管理任務,實例的數據字典都在SYS下 |
SYSMAN | OEM_TEMP | 企業管理器帳戶 |
SYSTEM | 安裝時確定 | 用于執行數據庫管理任務,有少量的實例對象 |
WK_TEST | WK_TEXT | 管理ORACLE10gULTRASEARCH的帳戶,和WKSYS有一樣的作用 |
WKPROXY | 未知 | ORACLE10g與代理服務器有關的帳戶 |
WKSYS | WKSYS | 管理ORACLE10gASULTRASEARCH帳戶,與WK_TEST有一樣的作用 |
WMSYS | WMSYS | 工作空間管理帳戶 |
XDB | CHANGE_ON_INSTALL | XMLDB帳戶 |
TSMSYS | Oracle 10g的所有目錄上的特點及與此相關的觀點/表的新特征是儲存在TSMSYS用戶下 | |
oracle_ocm | Oracle 預定義的非管理員用戶 | |
FLOWS_FILES | 是Oracle Application Express的系統賬號,該賬戶擁有oracle application express上傳的文件。 | |
appqossys | Used for storing/managing all data and metadata required by Oracle Quality of Service Management. | |
apex030200 | APEX產品數據庫用戶,其中ORACLE 的信息生命周期管理工具ILMA的使用前提是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$NULL | |
BI | 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 | 實驗、測試用戶,含有例表products、sales、customers等 可以修改密碼,用戶可以被刪除,在產品環境建議刪除或鎖定 | |
OE | 示例用戶 | |
HR | 實驗、測試用戶,含有例表empLoyees與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 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. |
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。