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');
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