|
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.
|
|
I would like to do both of the following things:
use audit triggers on my database tables to identify which user updated what; use connection pooling to improve performance For #1, I use 'system_user' in the database trigger to identify the user making...
Started by Gern Blandston on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It....
Store the user from your web application in the database and let your triggers go off that stored data .
Identifying the user just from the database connection AND sharing database connections between users are mutually exclusive .
Unfortunately, no.
|
|
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
|
Hi there!
So I'm in a bit of a sticky situation. I'm a sophomore in college as a Musical Theater Major. I have had a lot of success at my school, but crazy things are going down, and I need to transfer. I didn't really figure out that I absolutely needed...
Started by coexist2014 on
, 15 posts
by 6 people.
Answer Snippets (Read the full thread at collegeconfidential):
Ha ha ha :-) Thanks so much, Halflokum! I know I didn't get in though--- they had a callback system.
|
|
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 am creating an audit table for tracking changes done on a record in main table.
Here audit table is the exact duplicate of main table (say Employee Table) but will only have 'inserts' for every changes happens in the main table. So it will have duplicates...
Started by LittleBoy on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You can visualize "the changes from audit-id to audit-id+1 " far more easily....
You could use the employee id and the audit datetime, since it allows you to reference it in a pragmatic way.
It yourself and make if visible and usable.
|
|
Hi
I need to list all AUDIT command issued.
I'm using the DBA_STMT_AUDIT_OPTS view, but it doesn't list all of them.
For example if a run this command:
audit create session by my_user;
the DBA_STMT_AUDIT_OPTS will list it.
But if I run this command:
audit...
Started by paulogervasio on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at dbaforums):
I wanna also to list the AUDIT for objects, because DBA_STMT_AUDIT_OPTS list the audit only for the systemHi Paulo,
Please read, you misunderstand this view:
http://www.dba-oracle.com/t_dba_stmt_audit_opts.htm
>> need....
|
|
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'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.
|
|
My requirement is for a data model where a full audit trail is retained for changes to every attribute of every object. Object definitions are also fluid: new attributes can appear or go away over time. This audit trail will live separately from the original...
Started by jmay on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
But our auditing is through triggers and we have a separate ....
Log calls to every function that modifies if the audit database is on another server and the conectin is down.
You can also create a logging system in application code.
|
