Skip to Main Content
  • Questions
  • Find out who is making direct updates to tables

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Arun.

Asked: December 15, 2016 - 8:45 pm UTC

Last updated: December 16, 2016 - 3:37 am UTC

Version: 11g : 11.1.0.7.0

Viewed 1000+ times

You Asked

Hi,

There have been a couple of instances where a user has made direct updates to an EBS table. Is there any way (other than turning on audit) to find out who made these changes. We created a database trigger on these tables but it captures only what changed but not who made these changes.

Could you please help.

Thanks

and Connor said...

If you can use a trigger, you can capture more information.

Check out the details you could log via the SYS_CONTEXT function

http://docs.oracle.com/database/121/SQLRF/functions199.htm#SQLRF06117

and you could also use SYS_CONTEXT('userenv','sid') to query v$session to anything from v$session that is not picked up in the context.

So you can get things like machine, terminal, osuser, ip address etc.

But if they are making changes, then they either have privileges under their own schema, or they know the owning schema passwords....Both dont sound like a good idea.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library