postgresql数据库密码存储位置 plsql数据库密码存储位置

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.