6 Replies Latest reply on Jan 14, 2019 5:57 PM by racman

    EXPIRY_DATE isn't change for SYS just now.

    3197218

      1.check EXPIRY_DATE

      select USERNAME,EXPIRY_DATE from dba_users where username='SYS';

       

      USERNAME

      --------------------------------------------------------------------------------

      EXPIRY_DATE

      -------------------

      SYS

      2019-01-15 14:33:58

       

      2. run alter statement. It used to change EXPIRY_DATE

      alter user sys identified by <passwd>;

       

      User altered.

       

      3. But check again, it's not changed.

      select USERNAME,EXPIRY_DATE from dba_users where username='SYS';

       

      USERNAME

      --------------------------------------------------------------------------------

      EXPIRY_DATE

      -------------------

      SYS

      2019-01-15 14:33:58

       

      It really puzzles me. Anybody knows why?