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

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