In a .NET RecordAddin I am trying to modify record notes, however we don't want to give end user record admin access to modify Record Notes, so obvioiusly this would cause "Access Denied" error when the RecordAddIn is trying to modify notes. So i thought i'll let the RecordAddIn emulate as an TRIM admin when modifying Record Notes through the TRIMDB.ConnectAs(username, password) method, but so far no joy. In the user profile I've give the user permission to impersonate as another user under Miscellanous, and enabled user to be impersonated, but still getting following error:
Error connecting to TRIM dataset 'test' on workgroup 'workgroup5'. Remote: Impersonated logon failed. The account AAA\jsmith is not trusted to impersonate other HP TRIM users.
so i then tested adding AAA\jsmith to the trusted user on TRIM enterprise studio, that fixed the above problem, (but i hate to add every single user as a trusted user if that's what i have to do). I then created a TRIM administrator, and call TRIMDB.ConnectAs(username, pwd) to emulate as the TRIM administrator. However I'm still getting the access denied error when attempting to modify Record Notes using Record.Notes = "some new string".
So my question is:
1. how would you guys go about allowing RecordAddIn modify RecordNotes while not giving user full Record Notes access?
2. if you go via the emulate route, is there a way to allow let RecordAddIn to emulate as another user without adding that user as a trusted user? and why even when emulated as an administrator, i'm still getting access denied error when modifying record notes?
Sorry about my wordy problem, any help is greatly appreciated