Oracle提示错误消息ORA

WBOY
Release: 2016-06-07 15:15:01
Original
1108 people have browsed it

Oracle提示错误消息ORA-28001: the password has expired 解决办法: 1、利用SYSDBA权限登陆; 2、查看账户信息: select username,account_status from dba_users 3、如果账户locked/ expired, 得先解锁: alter user BJMMIS account unlock; 再修改密码 a

Oracle提示错误消息ORA-28001: the password has expired


解决办法:

1、利用SYSDBA权限登陆;

2、查看账户信息:

select username,account_status from dba_users

3、如果账户locked/expired,

得先解锁:

alter user BJMMIS account unlock;

再修改密码

alter user BJMMIS identified by newpwd;

一劳永逸破解11G180天自动密码失效的办法:

查询密码有效期

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'

修改为无限制:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!