Is there anyway to override user access in LotusScript?
I have script in a form QuerySave event that should update a field in a matching document in another database. Unfortunately, most users only have reader access to this other database. We kind of need to keep it that way.
no way that I know of (unless you change their access, and then remove it). You could have an agent signed by the server that gets executed and have it update the other dB. John
If you’ll look at the security sidebar - a table which displays what security rights are used in what situation - in the Agent FAQ - it will give you all these permutations at a glance.
Just an idea, move your code from querysave into an agent and have the querysave event do a RunOnServer(noteid), that way, it would be a server based agent - which the server should have access to the other database.
Another method is create children documents in your current database. They would contain your key and data that needs to get pushed to the read only database. Then every night (or hour), have an agent run to update the other database based on the children documents and then delete the children docs.