Oracle 11 g：how to change the password with PL/SQL

最新推荐文章于 2022-07-02 17:53:23 发布

Liu_Fengming

最新推荐文章于 2022-07-02 17:53:23 发布

阅读量1.1k

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/iluckyflower/article/details/12947427

版权

Oracle 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as SYS

SQL> Select username,password from dba_users;

USERNAME PASSWORD
------------------------------ ------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
LFM_BO31
BOR2_REPO
EXFSYS
SCOTT
OUTLN
FLOWS_FILES
MDSYS
ORDSYS
WMSYS
APPQOSSYS
APEX_030200
OWBSYS_AUDIT
ORDDATA
CTXSYS
ANONYMOUS

USERNAME PASSWORD
------------------------------ ------------------------------
XDB
ORDPLUGINS
OWBSYS
SI_INFORMTN_SCHEMA
OLAPSYS
ORACLE_OCM
XS$NULL
BI
PM
MDDATA
IX
SH
DIP
OE
APEX_PUBLIC_USER
HR
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR

38 rows selected

SQL> alter user scott identified by 123456;

User altered

SQL> conn scott/123456
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott

SQL>