SELECT username,profile FROM dba_users;
一般用户的profile设置都为DEFAULT。- SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
- PROFILE RESOURCE_NAME RESOURCE LIMIT
- ------------------------------ -------------------------------- ------------------------------------------------
- DEFAULT PASSWORD_LIFE_TIME PASSWORD 180dys
3. 修改DBA_PROFILES中PASSWORD_LIFE_TIM的设置,改为ULIMITED。ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
修改后设置立即生效,不需要重启数据库,此时密码永远不会过期。- sqlplus / as sysdba
- alter user system identified by root;
再连接数据再也不会出现密码过期的事情了。alter user scott identified by tiger;
联系客服