-
Created and Last updated IDs
Hi,
Does Oracle have any function which can help me keep track of whose has inserted(created) a row and whose has updated the same row latest?
Uptill now, I am doing it via a bit of coding, but are there any functions which help me do the same?
Suresh
-
You could have a date stamp field in the table and a trigger to update this field each time any data manipulation like insert or update is done.
thomasp
-
If you want something "out of the box", I guess the best option is to use Auditing, specifically Fine Grained Auditing (FGA):
http://www.oracle-base.com/articles/...ained_auditing
Then again, there is nothing wrong with the previous suggestion. I use it myself on occasion
Cheers
Tim...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|