Thursday, 8 February 2018

Update Oracle db users password with same password

To update Oracle DB users password with same password when it is going to expire.

select name,password from sys.user$ where name in('ATLAS_RO');

select username,account_status,expiry_date from dba_users where username in('ATLAS_RO');

spool user_password.sql
select 'ALTER USER '||name||' IDENTIFIED BY VALUES '||''''||password||''''||';' from sys.user$ where name in('ATLAS_RO');
spool off
@user_password.sql

select username,account_status,expiry_date from dba_users where username in('ATLAS_RO');

No comments:

Post a Comment