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
Post a Comment