How Do You Tell When the SYS Password was Changed in Oracle 12.2
From: MacGregor, Ian A. <"MacGregor,>
Date: Mon, 7 Jan 2019 18:24:54 +0000
Message-ID: <BYAPR07MB490100B526A2A19EB049A745E2890_at_BYAPR07MB4901.namprd07.prod.outlook.com>
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.
Date: Mon, 7 Jan 2019 18:24:54 +0000
Message-ID: <BYAPR07MB490100B526A2A19EB049A745E2890_at_BYAPR07MB4901.namprd07.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 07 2019 - 19:24:54 CET