Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I know when a password for a role was last changed?
"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 DykstraReceived on Wed Oct 04 2006 - 14:36:54 CDT
![]() |
![]() |