|
Guys,
The topic of how to audit tables has recently sprung up in our discussions... so I like your opinion on whats the best way to approach this. We have a mix of both the approaches (which is not good) in our database, as each previous DBA did what ...
Started by UB on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
So if you....
With :
Appraoch 2: Store, in audit table, every record that goes into main table ( using system tableA third approach we use alot is to only audit the interesting columns, and save both 'new' and 'old' value on each row.
|
|
So basically I'm building an app for my company and it NEEDS to be built using MS Access and it needs to be built on SQL Server.
I've drawn up most of the plans but am having a hard time figuring out a way to handle the auditing system.
Since it is being...
Started by Andrew G. Johnson on
, 21 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
System Datasource) Select * from your audit table....
@KevinKenny I would say to the datasource by creating a linked table Select Machine datasource Pick New.. .
Then you can pickup the logged on user using the SYSTEM_USER function.
|
|
How can REVOKE operations on a table be audited in Oracle? Grants can be audited with...
AUDIT GRANT ON *schema.table*;
Both grants and revokes on system privileges and rolls can be audited with...
AUDIT SYSTEM GRANT;
Neither of these statements will ...
Started by Leigh Riffel on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at stackoverflow):
Run audit grant table; This covers both GRANT and REVOKE privileges ON tables views and materialized.
Set the parameter audit_trail to db_extended .
Set the parameter audit_sys_operations to true .
|
Ask your Facebook Friends
|
I already audit authorization success, failure and logout.
I've considered auditing (logging) every method call and keeping a version of every row and column that was ever modified, but both of those options will greatly increase the complexity of auditing...
Started by MatthewMartin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The root is what you log, for example it to the root, if it is important... .
Think of your application's audit-elements as a tree of events.
Between calls/table alterations and some audit-message would be beneficial too (if you have resources).
|
|
Hi all, My first question on here so be nice!
I am a junior developer with not much experience and am having trouble with this problem.
I have a table which needs to be auditable. Let's say this table records phone calls made by a call centre (it's not...
Started by Andrew on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If you are a junior developer, it is nice to have in mind all possible solutions, but probably you should listen to a senior developer, who knows about your system.
Requirements to the system.
|
|
I use the following tools for my auditing needs
A) System Auditing and Hardening (One time)
1) Linux Security Auditing Tool (Security centric,Text based output )
2) Dmidecode ( Retrieves info from BIOS )
3) Systeminfo ( Generates a nice html report)
4...
Started by Sharjeel Sayed on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
A tool that I find for external audits in system software, or the way....
Every day which details different things that are going on in my system (everything from mailqueues" audit tools, and generally are installed on the box.
|
|
I have a need to do auditing all database activity regardless of whether it came from application or someone issuing some sql via other means. So the auditing must be done at the database level. The database in question is Oracle. I looked at doing it...
Started by GotoError on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
What, exactly, are you looking to audit? Data changes? Queries? Something else?
If you want to audit every query....
I'm not sure if it's a mature enough approach for a production system, but I had quite a lot what you're looking for.
|
|
I have a system that runs a lot of cronjobs. It seems that one of these crons is consuming excessive amounts of CPU and memory on occasion.
Is there an easy way to audit CPU and memory usage of cron jobs?
Started by Ben K. on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Accounting
Have you considered launching the commands manually to audit them?.
|
|
I'm looking at changing our Auditing process for our SQL Server 2005 databases and I came across Change Data Capture in SQL Server 2008.
This looks like a good idea, and I'm tempted to try it, but before I do has anyone used it in a commercial environment...
Started by MrEdmundo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I have implemented audit trail solutions intensive for highly transactional databases....
Find moreThe CDC should is just a means to an end in my opinion .
2008, you can use the "Audit" feature and stock data on a file, app log or system log.
|
|
I know Audit System Events is an option in the Default Domain Controller GPO.
But on two DCs (isolated Forest) they also have Audit System Events as option available in the Default Domain Policy. No advanced auditing is set. I'm just talking about the...
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at microsoft):
|
