create separate db user for audit trail

Question

0.00/5 (No votes)

See more:

I have a database which is used for a web application(not website).

For each web application user, Is it advisable to create separate db user?

Now I have a single db user to access from the web application. My objective is to have an audit trail for any update or delete. If I am using AFTER DELETE Trigger, I am not able to identify the exact user who is deleting the record.

Please advise me the right way to go ahead.

Thank you in advance.

Posted 21-Dec-13 21:30pm

Murugan Kolanji

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2013-12-21T21:44:00

Solution 1

No. If you want to track use, require a login and store the user id for actions they do.

Posted 21-Dec-13 21:44pm

Christian Graus

Comments

[no name] 22-Dec-13 6:47am

But how e.g. triggers can then be f(user)? A beginners question ;)

Christian Graus 22-Dec-13 16:42pm

You write triggers and use them. They are an unrelated question, and your best bet is to read an online article with examples, not rely on a forum post ( I will write an article on triggers in time, but I have not yet ).

Murugan Kolanji 23-Dec-13 1:51am

right now, we are using trigger only. but we cant get the user details while raise delete trigger.

Christian Graus 23-Dec-13 4:12am

So your real question should be, we have a trigger, here's the code, here's the table definition, and here's what we are having trouble doing ?

JoCodes · Answer 2 · 2013-12-22T00:44:00

Solution 2

There should not be separate DB for Audit trails.

Refer the link added which can give a fair idea on the best practices for creating and maintaining audit trails.

http://www.4guysfromrolla.com/webtech/041807-1.shtml[^]

Hope this helps...

Posted 22-Dec-13 0:44am

JoCodes