Oracle数据库用户的密码保存位置说明

sysdba的密码可以存在口令文件中。其它数据库用户密码存在数据库中的sys.user$表中。

具体实验验证如下：

[oracle@db dbs]$ pwd

/u01/app/oracle/product/11.2.0/db_1/dbs

[oracle@db dbs]$ ls

hc_orcl1.dat  hc_orcl.dat  lkORCL  orapworcl.bak  spfileorcl.ora  --将原有密码文件改名为 orapworcl.bak

无密码文件的情况下，通过plsql登录数据库，sys登录失败、其他用户登录成功。

创建密码文件后，sys用户通过plsql登录数据库成功：

[oracle@db dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl password=oracle entries=5 force=y

非dba用户密码存放在sys.user$中，如下：

SQL> select name,password from sys.user$;

NAME                           PASSWORD

------------------------------ ------------------------------

SYS                            8A8F025737A9097A

PUBLIC

CONNECT

RESOURCE

DBA

SYSTEM                         2D594E86F93B17A1

SELECT_CATALOG_ROLE

EXECUTE_CATALOG_ROLE

DELETE_CATALOG_ROLE

OUTLN                          4A3BA55E08595C81

EXP_FULL_DATABASE

NAME                           PASSWORD

------------------------------ ------------------------------

IMP_FULL_DATABASE

LOGSTDBY_ADMINISTRATOR

DBFS_ROLE

DIP                            CE4A36B8E06CA59C

AQ_ADMINISTRATOR_ROLE

AQ_USER_ROLE

DATAPUMP_EXP_FULL_DATABASE

DATAPUMP_IMP_FULL_DATABASE

ADM_PARALLEL_EXECUTE_TASK

GATHER_SYSTEM_STATISTICS

JAVA_DEPLOY

NAME                           PASSWORD

------------------------------ ------------------------------

ORACLE_OCM                     5A2E026A9157958C

RECOVERY_CATALOG_OWNER

SCHEDULER_ADMIN

HS_ADMIN_SELECT_ROLE

HS_ADMIN_EXECUTE_ROLE

HS_ADMIN_ROLE

GLOBAL_AQ_USER_ROLE            GLOBAL

OEM_ADVISOR

OEM_MONITOR

DBSNMP                         FFF45BB2C0C327EC

APPQOSSYS                      519D632B7EE7F63A

NAME                           PASSWORD

------------------------------ ------------------------------

WMSYS                          7C9BA362F8314299

WM_ADMIN_ROLE

JAVAUSERPRIV

JAVAIDPRIV

JAVASYSPRIV

JAVADEBUGPRIV

EJBCLIENT

JMXSERVER

JAVA_ADMIN

XS$NULL

EXFSYS                         33C758A8E388DEE5

NAME                           PASSWORD

------------------------------ ------------------------------

CTXSYS                         71E687F036AD56E5

CTXAPP

XDB                            88D8364765FCE6AF

ANONYMOUS                      anonymous

XDBADMIN

XDB_SET_INVOKER

AUTHENTICATEDUSER

XDB_WEBSERVICES

XDB_WEBSERVICES_WITH_PUBLIC

XDB_WEBSERVICES_OVER_HTTP

OLAP_DBA

NAME                           PASSWORD

------------------------------ ------------------------------

ORDSYS                         7EFA02EC7EA6B86F

ORDDATA                        A93EC937FCD1DC2A

ORDPLUGINS                     88A2B2C183431F00

SI_INFORMTN_SCHEMA             84B8CBCA4D477FA3

MDSYS                          72979A94BAD2AF80

ORDADMIN

OLAP_XS_ADMIN

OLAPSYS                        4AC23CC3B15E2208

OWB_USER

CWM_USER

OLAP_USER

NAME                           PASSWORD

------------------------------ ------------------------------

MDDATA                         DF02A496267DEE66

SPATIAL_WFS_ADMIN

SPATIAL_WFS_ADMIN_USR          7117215D6BEE6E82

WFS_USR_ROLE

SPATIAL_CSW_ADMIN

SPATIAL_CSW_ADMIN_USR          1B290858DD14107E

CSW_USR_ROLE

SYSMAN                         2CA614501F09FCCC

MGMT_USER

MGMT_VIEW                      395C2DC2E3376A62

FLOWS_FILES                    A615F72D8D4B7A3D

NAME                           PASSWORD

------------------------------ ------------------------------

APEX_PUBLIC_USER               3C91E6A20F0770EC

APEX_ADMINISTRATOR_ROLE

APEX_030200                    059E9CA418F39DED

OWBSYS                         46FFE7B1869A6388

OWBSYS_AUDIT                   3378320729DADFE1

OWB$CLIENT                     13D492A4459DFE0D

OWB_DESIGNCENTER_VIEW

_NEXT_USER

SCOTT                          F894844C34402B67

TEST                           7A0F2B316C212D67

87 rows selected.