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

Fetch Members from Workgroup

  import java.util.ArrayList;   import java.util.Iterator;   import java.util.List;   import sailpoint.api.ObjectUtil;   import sailpoint.ob...