Reuse password for multiple grace account in Oracle Database

 Reuse password for multiple grace account in Oracle Database


Below query will provide you query to run after that.


select 'alter user '|| s.username|| ' identified by values ''' ||u.password || ''' account unlock;' from dba_users s, sys.user$ u where s.username=u.name and s.account_status like '%GRAC%';

Comments