Hi Jean Guy, Are you talking about record auditing???
You could do that with something like this: # This sets a variable for user_id which is used frequently # it must be set after db.py or in db.py but after auth tables have been defined # and before the table referring to it. user_id = auth.user.id if auth.user else 0 db.define_table('application', Field('title'), Field('body', 'text'), Field('created_on', 'datetime', default=request.now), Field('created_by', db.auth_user, default=user_id)) db.application.title.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'application.title')] db.application.body.requires = IS_NOT_EMPTY() db.application.created_by.readable = False db.application.created_by.writable = False db.application.created_on.readable = False db.application.created_on.writable = False If you are allowing editing you could copy the original record and create a new one. web2pyslices has a nice example. Cheers, Chris On Jun 8, 6:29 pm, Jean Guy <jean...@gmail.com> wrote: > Could it be a good practice to implement electronic signature of the > database records like this : > > db.define_table('atable', > SQLField('var1'), > SQLField('var2',default=db(db.auth_user.id > ==auth.user_id).select(db.auth_user.initials).first().initials)) > > It needs that the user be authentified otherwise the app won't work, but as > long as the user as to be authentified for doing accessing the database, it > should be ok... > > What do you think? > > My goal is to have each records signed (stamped with users initials > actually) at the database level. > > Thanks. > > Jonhy