Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When was password changed?
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.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Jan 14 2004 - 18:53:23 CST