Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: The last date/time of changing password??
Connor McDonald ¼¶¼g©ó¤å³¹ <36A59A87.4DEE_at_bhp.com.au>...
>Donald Yeh wrote:
>> A user can change his password using 'ALTER USER ......'.
>> How can I get the last date/time of changing password?
>> Which data dictionary store the infomation?
>
>I don't think it is stored...
>For password expiry (in Oracle 8 - it aint there in 7), all the database
>needs to know if when you password will expire (cf: EXPIRE_DATA in
>DBA_USERS)...
No. Oracle stores the time in the column SYS.USER$.PTIME.
You can see this column in the view SYS.DBA_USERS.
Received on Sat Feb 27 1999 - 22:21:46 CST