Re: User access security linking with table records
- From: Jamie Collins <jamieuka@xxxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2007 04:51:14 -0700
On Sep 24, 1:22 pm, Nick <N...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am building a multiple user database with user access security and I would
like to add some code so that every record added by each user has that user's
user name included in each record
I would suggest that adding such metadata to every row in every table
will only lead to pain; what will happen when they want field-level
metadata...? Also consider that an audit trail is usual external by
design: how can you ensure bias will not be introduced into your
design by accident or otherwise? i.e. who will audit the audit tool?!
My suggestion is to consider porting the data to a more capable
engine, one that supports triggers (makes capturing changes much, much
easier), and purchasing an appropriate (e.g. SOX-compliant) tool for
the job rather than rolling your own.
Jamie.
--
.
- Prev by Date: 2455 Error when navigation bar set to not show Access 2007
- Next by Date: Re: User access security linking with table records
- Previous by thread: RE: User access security linking with table records
- Next by thread: Re: User access security linking with table records
- Index(es):
Relevant Pages
|
