How Do You Tell When the SYS Password was Changed in Oracle 12.2

  • From: "MacGregor, Ian A." <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "ian" for DMARC)
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 7 Jan 2019 18:24:54 +0000

We use the ptime  column of  the sys.user$ table to monitor password change 
times.  This still works for a normal user, but for sys the value does nit 
change.  This is true whether "alter user" or the password command is used.






Ian A. MacGregor
SLAC National Accelerator Laboratory

Other related posts: