Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1074127927.269013_at_yasure>...
> Forte Agent wrote:
>
> > Given a database schema, is there some way to find out when its
> > password was last changed? Thank you in advance.
> >
>
> SELECT *
> FROM user_history$;
>
> Provided, of course, you are using a PROFILE to control such goings on.
If you are not using profiles to control password strength (but you
should be), then another option is Oracle's audit trail. If you have
auditing on, and if you are auditing ALTER USER, then the audit trail
may help. Keep in mind that this only tells you that an alter user
was done, but it could have been a DBA altering that user's temp
tablespace or something. If it shows that user altering themself,
then it's most likely a password change.
--
Joe
http://www.cafeshops.com/joekaz
http://www.joekaz.net
Received on Fri Jan 16 2004 - 07:28:10 CST
