Prompt for password to save record

[JTI]

I implemented access security and a user log on system, so depending on your logon you can perform various functions etc.

The issue is I have multiple users with the same roles and would like to capture which one approves the record, so I would like them to verify their password before completing a record, kind of a digital signature, not 100% fool proof I know.

I have searched but haven't been able to find a similiar question, any help appreciated.

 

[wiklendt]

maybe just have them 'log in' to the database and use the logged-in userID append to the approve table? i'm not an expert in this, but if you search environment and user in these forums you'll get lots of hits regarding these options.