Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: last time password was changed

Re: last time password was changed

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 28 Mar 2006 23:08:10 +0800
Message-Id: <6.2.1.2.0.20060328230648.01fce1c0@pop.singnet.com.sg>

R11.0.3 to 11.5.9 with O7_DICTIONARY_ACCESSIBILITY=TRUE. Query SYS.USER$.PTIME.

11.5.10 + 9.2.0.5 with O_D_A=FALSE, you need privileges to query SYS.USER$

Hemant

At 10:55 PM Tuesday, Zelli, Brian wrote:
>Hello all,
> For SOX purposes, is there a location on the system that tells me when
> the last time a password was changed? I need to know when the apps user
> was last changed.
>
>ciao,
>Brian
>
>----------

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 28 2006 - 09:08:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US