473,238 Members | 1,759 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,238 software developers and data experts.

creating Trigger for every table in a database

Hi

Lets say I have a table MyUser (column: MyuserID, Username)

Another table Product (column: ProductID, ProductName)

Then I created a table MyUser_Audit (column: MyUserID, Username, audit_action, Audit_Timestamp) to store all the audit trail.

And now, user01 with name Mary inserted ProductID and ProductName into the Product table.

How do I create a trigger to audit trail the action and store it into the MyUser_Audit table?


Thank you
Apr 9 '11 #1
1 1828
ck9663
2,878 Expert 2GB
Here's primer.

Good Luck!!!

~~CK
Apr 13 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Ex-Em-El | last post by:
I have a problem in creating a dynamic table in the same xml : 1.xml: <?xml version="1.0" standalone="yes"?> <?xml-stylesheet type="text/xsl" href="2.xsl"?> <aaa...
11
by: randi_clausen | last post by:
Using SQL against a DB2 table the 'with' key word is used to dynamically create a temporary table with an SQL statement that is retained for the duration of that SQL statement. What is the...
2
by: alex.mcshane | last post by:
Hi - I would be grateful for guidance on the following. The following concerns the DDL for Creating an Auxilliary Table that is associated with the CLOB column of a 'base' Table. (I have just...
6
by: Lewis Veale | last post by:
I have an Access 2000 front-end pointing at a SQL Server backend, with around 80 linked tables and views. I frequently need to point the front-end at different versions of the back-end, and achieve...
2
by: Barry | last post by:
Hi can anyone tell me if there if any code snippet available for creating a SQL Server Database and Table using C# web application. TIA Barry
1
by: abhu50 | last post by:
hiiiiiiii i wan to create trigger for table emp0 attribute are:- eno ename sal dno now i want to contro insertion on emp0 by using trigger that will allow only those record having...
2
by: tommurray | last post by:
Im looking for a little help and guidance on creating a league table from entries in a database, because of other requirements it is not possible to update the entry for the person in the database....
3
devikacs
by: devikacs | last post by:
I wanted to know the overhead in creating a new table. What i mean is, is it better to have more tables or redundant columns in a single table.
2
by: popprem | last post by:
Hi, I have to feed database A from database B which are in different machines but in the same network when a insert/update occurs on database B. I decided to use trigger for this and was trying...
4
by: Green831 | last post by:
Hello, I am fairly new to Access 2007 I can make a table, queries, forms and reports but am largely doing so through the wizard function and then modifying the structure of each for my purposes. ...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.