Home » RDBMS Server » Server Administration » Accessing Single schema from multiple schema logging. (Oracle 10g)
icon7.gif  Accessing Single schema from multiple schema logging. [message #507489] Mon, 16 May 2011 04:46 Go to next message
pradeep2002gs
Messages: 19
Registered: August 2009
Junior Member
Hi Geeks,

I have a scenario,

A single master schema where many developers are accessing.
all share same password.

now i would like to trace all the changes made by each users.
so i create a individual users for all and grant permission to access that schema.do i have a possibility of auditing the changes did by each user for that particular schema


Thanks in Advance.
Pradeep

Report message to a moderator

Re: Accessing Single schema from multiple schema logging. [message #507498 is a reply to message #507489] Mon, 16 May 2011 05:59 Go to previous messageGo to next message
cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oracle auditing should do exactly that.

Report message to a moderator

Re: Accessing Single schema from multiple schema logging. [message #507504 is a reply to message #507489] Mon, 16 May 2011 06:20 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
AUDIT

Regards
Michel

Report message to a moderator

Previous Topic: Data Block Corruption
Next Topic: Kill zombie
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 06:48:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.