This content has been marked as final. Show 4 replies
select profile from dba_users where username = 'SYSTEM';
But as a good practice, password must expire and changed , isn't it?
Which profile is being used by the user System ? Are you sure its the Default profile?
you have not assigned profile to the user which you have set never expire password,
check which profile you have assigned
alter user user1 profile default;Thanks
Run the below query
SQL> alter profile default limit password_life_time unlimited;
After doing this...Reset the password of the user again.
SQL> alter user test identified by test123;
By doing this,the password will never expire.