oracle 密码重置，

最新推荐文章于 2023-03-03 16:21:41 发布

原创最新推荐文章于 2023-03-03 16:21:41 发布 · 516 阅读

0 ·

CC 4.0 BY-SA版权

数据库和Oracle 专栏收录该内容

88 篇文章

订阅专栏

本文展示了如何使用SQL*Plus工具连接Oracle11g数据库，并通过具体命令实例介绍了如何更改用户密码以及设置默认配置文件中密码的有效期。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

D:\app\Administrator\product\11.2.0\dbhome_1\BIN>
D:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 20 13:52:36 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user sys identified by password;

User altered.

SQL> alter user ACHADMIN identified by ACHADMIN;

User altered.

SQL> alter user ACHSPADMIN identified by ACHSPADMIN;

User altered.

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL>