查询密码过期时间,默认180
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
alter user system identified by 123456
查询密码过期时间,默认180
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED