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

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I know when a password for a role was last changed?

Re: How do I know when a password for a role was last changed?

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 04 Oct 2006 19:36:54 GMT
Message-ID: <q3UUg.1781$H7.982@edtnps82>


"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:452407c1$0$10704$426a74cc_at_news.free.fr...
>
> "Terry Dykstra" <tddykstra_at_forestoil.ca> a écrit dans le message de news:
> %kTUg.1774$H7.494_at_edtnps82...
> | Our SOX auditors are asking this. I cannot find any view/table that has
> | this information.
> | I'm running both 817 SE and 9207 SE.
> |
> | --
> | Terry Dykstra
> |
> |
>
> SYS.USER$.PTIME
>
> Regards
> Michel Cadot
>
>

That's an obvious place!
Unfortunately, both 817 & 9207 (running on W2K) do not populate PTIME for roles.
In the mean time I've turned on auditing (AUDIT ROLE) to track changes to roles.

-- 
Terry Dykstra 
Received on Wed Oct 04 2006 - 14:36:54 CDT

Original text of this message

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