处理：“ORA-28002: the password will expire within 7 days”的问题-白红宇

处理：“ORA-28002: the password will expire within 7 days”的问题

阅读量：6995 次

发布时间：2019-06-27

本文共 1069 字，大约阅读时间需要 3 分钟。

一：问题描述：

二；处理步骤

[oracle@localhost 2018_07_14]$ rlwrap sqlplus /  sysdba;*Plus: Release 11.2.0.3.0 Production  Sat Jul 14 18:53:53 2018Copyright (c) 1982, 2011, Oracle.   rights reserved.Connected :Oracle  11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining   Application Testing optionsSYS@orcl>  username ,profile  dba_users  username ='SCOTT';USERNAME                       PROFILE------------------------------ ------------------------------SCOTT                          SYS@orcl>  *  dba_profiles s  s.profile ='DEFAULT'  resource_name ='PASSWORD_LIFE_TIME';PROFILE                        RESOURCE_NAME                    RESOURCE------------------------------ -------------------------------- --------LIMIT----------------------------------------                        PASSWORD_LIFE_TIME               PASSWORD180SYS@orcl>  profile  limit password_life_time unlimited;Profile altered.SYS@orcl>   scott identified  scott; altered.SYS@orcl> conn scott/scottConnected.SCOTT@orcl>

转载于:https://www.cnblogs.com/ios9/p/9310956.html

你可能感兴趣的文章