Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Logging of changes on a table
"Lars Windels" <windels_at_swms.de> wrote in message news:<a3dti9$ksi$02$1_at_news.t-online.com>...
> Hello.
>
> Is there a way to get the information when a specified user has modified the
> datasets from a table?
>
>
> Best regards
>
> Lars Windels
If you mean is there a way to know if a user modified a particular table then you have a couple of options:
You can configure Oracle's built-in auditing feature using the audit command. You have the ability to audit access by session or by access based on the DML issued. See the DBA Administrators Guide and the SQL manual for details. It is also possible to audit a user should the need arise.
You can place before insert/update triggers on the table and capture the fact a row has been changed.
Both methods require you set them up in advance. In the case of something that just happened and neither of these options are in use you might be able to use the log miner utility to scan the redo logs for proof of what you suspect.
![]() |
![]() |