1-Login to database as SYS user or OVS user
2-Take a backup from OVS_USER table
create table OVS_USER_BKP as select * from OVS_USER;
3-Run the command below:
UPDATE OVS_USER set password='testepasswd' where account_name='ADMIN';
commit;
4-Encrypt the password with this command below:
UPDATE OVS_USER set password=create_encrypt_passwd('testepasswd') where account_name='$USER';
commit;
Best Regards,
Paulo Portugal
No comments:
Post a Comment