Wednesday, February 6, 2019

Oracle Password

- sqlplus opera/opera@opera 
- update application$_user set app_password='BETTERTHANV6' where app_user='SUPERVISOR';
 - commit;
 - exit


SQL> update opera.application_user set app_password='BETTERTHANV6' where app_user='SUPERVISOR';

 

 SQL> update opera.application_user set account_locked_out_yn='N' where app_user='SUPERVISOR';



        SQL> update opera.application_user set lockout_date=NULL where app_user='SUPERVISOR';

 SQL>commit;


 SQL>exit;