Friday, December 18, 2020

Change / Update the end date for XELSYSADM user

update USR 

set usr_pwd_warn_date=null, usr_pwd_expire_date=null, usr_pwd_never_expires='1'  

where usr_login='XELSYSADM';

commit;

                                                                    (OR)

update USR 

set usr_pwd_warn_date=null, usr_pwd_expire_date='01-04-21', usr_pwd_never_expires='1'  

where usr_login='XELSYSADM';

commit;


NOTE : 

Date :   dd/MM/yy

No comments:

Post a Comment

Content Assist set up in Eclipse

# Open the Eclipse application # Navigate to Windows > click on Preferences # Navigate to Java and expand it # Navigate to Editor a...