Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PMoloney
Starting Member
1 Post |
 Posted - 2011-07-05 : 00:29:30
|
| We are developing a small database application that will be used by approx. 20 users. It will contain some sensitive client information but no financial/accounting data. What are minimum audit requirements? Have considered created by/user and updated by/user on each record, and a log table but developer says this is over the top. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-07-05 : 02:54:25
|
| "Minimum audit requirements" is usually a management or government policy and it's impossible for us to say anything about what your policy should be. If however, you decide to go with the audit table and created/updated by on each record I've created a script that does all this for you (there are some prerequisites but hopefully it's understandable):http://thefirstsql.com/2010/05/21/create-an-audit-table-on-the-fly/- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
|
|
|
Audit requirements for small database