1、给当前用户解锁:alter user scott account unlock 2、查看用户的概要文件:select username,profile from dba_users;3、查看那密码过期限制:select * from dba_profiles s where s.profile='default' and resource_name='password_life_time';4、改为无限制:alter profile default limit password_life_time unlimited;
alter user TESTUSER password eXPire;
接着,TestUser试图连接其账户。当他输入口令时,立即被提示输入账户的新口令。
2、查看用户的概要文件:select username,profile from dba_users;3、查看那密码过期限制:select * from dba_profiles s where s.profile='default' and resource_name='password_life_time';4、改为无限制:alter profile default limit password_life_time unlimited;