Hi Ian,
That is because the password for the user SYS is maintained in the
password file:
[oracle@ora122 dbs]$ ls -l orapwo122
-rw-r----- 1 oracle oinstall 4096 Sep 27 19:37 orapwo122
The last password change was on 09/27/2018. Now, let's do one more
change today:
[oracle@ora122 dbs]$ sql / as sysdba
SQLcl: Release 12.2.0.1.0 RC on Mon Jan 07 14:18:57 2019
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter user sys identified by qwerty;
User SYS altered.
SQL>
Disconnected from Oracle Database 12c Enterprise Edition Release
12.2.0.1.0 - 64bit Production
And the date is changed:
[oracle@ora122 dbs]$ ls -l orapwo122
-rw-r----- 1 oracle oinstall 4096 Jan 7 14:19 orapwo122
[oracle@ora122 dbs]$
You only need file system utilities like "ls" to check the time of the
last change.
Regards
On 1/7/19 1:24 PM, MacGregor, Ian A. (Redacted sender ian for DMARC) wrote:
--
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
