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

Should be updating for non-SYS users as well , upto 11.2.0.4

See
https://hemantoracledba.blogspot.com/2011/11/alter-user-to-change-password-updates.html and Support Document# 312093.1

Hemant K Chitale

On Tue, Jan 8, 2019 at 3:24 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Hi Ian,
>
> That is because the password for the user SYS is maintained in the
> password file:
>
>
> [oracle_at_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_at_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_at_ora122 dbs]$ ls -l orapwo122
>
> -rw-r----- 1 oracle oinstall 4096 Jan 7 14:19 orapwo122
> [oracle_at_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
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l