Oracle 11 is expiring passwords. How do I reset this?

Navigation
2

Recently I migrated (six months ago) to Oracle 11 and now when using the command sqlplus system@INTANCIA I got the message below: 

ORA-28002: the password will expire within 7 days

NOTE: I can still log in and it only warns that the password will expire soon.

How do I configure my DBMS to not prompt for password change. This is a Development environment and I do not have security requirements at this level. I'd rather not introduce more complexity into the Scripts, however small.

    
asked by anonymous 11.03.2014 / 17:56

1 answer

4

To check the profile name associated with a given set of users: 

SELECT username, profile FROM dba_users 
WHERE username in ('SYSTEM', 'HR');

To check how a certain Profile is defined (in relation to the PASSWORD_LIFE_TIME setting) do: 

select resource_type, limit 
from dba_profiles 
where profile='DEFAULT' 
  and resource_name = 'PASSWORD_LIFE_TIME';

To change so that Oracle no longer expires the passwords use: 

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    
11.03.2014 / 18:09
Jquery function call How to calculate freight by ZIP in WooCommerce?