I wrote an expression plug-in that returns a writer. Every thing has worked fin

What kind of action does it perform? The type of security to be updated would be related to the action it's performing not to the function itself. For example, if the writer starts a process then the missing security is in the process security.

Thanks for quick response. I am trying to update a database table using JNDI datasource. I am trying to execute this in the context of a Report not Process. What should I do to make a Basic User allow database operation ?

The stack trace might tell you where this is failing but at a glance these are the things I'd check:

1. Data store security
2. Report security

Edurado, both data store and report has "CCAT All Users" as Viewers and the basic user is member of that group -

(APNX-1-4245-002)
          at com.appiancorp.process.expression.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:87)
          at com.appiancorp.process.expression.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:83)
          at com.appiancorp.core.expr.DelayedWriteContext.executeDelayedWrites(DelayedWriteContext.java:95)
          at com.appiancorp.core.expr.AppianScriptContext.writeDelayedExecutions(AppianScriptContext.java:516)
          at com.appiancorp.sail.UserInterfaceGenerator.processOneSaveRequest(UserInterfaceGenerator.java:238)
          at com.appiancorp.sail.UserInterfaceGenerator.generateUserInterface(UserInterfaceGenerator.java:116)
          at com.appiancorp.sail.UiServiceImpl$ValueUiEvaluator.eval0(UiServiceImpl.java:437)
          at com.appiancorp.sail.UiServiceImpl$TvUiEvaluator.eval0(UiServiceImpl.java:376)

I might need to see more of the stack trace then. Can you copy the whole thing from the time stamp of the error till the next error and attach it as text file?

Here is the full stack trace. thanks

APNX-1-4245-002.txt

Edurado, to give context behind the plugin - I am trying to save user preferences of the report to a very simple flat database table on the Report itself with in SAIL rules. Everything works beautifully for "Designer" but not for "Basic User". Since this is not in process model, I can not execute the script as "Designer". So, kind of stuck. I am using a Writer function to follow best practices.

Ok it seems the issue is in your code itself. Let's do one more test before I dig into your code.

Add the basic user to the Designers group and let me know if that works, if it does then we'll fix your code to remove this need.

Edurado, pardon for my asking. Which "Designers" are you referring to ?

The Group called "Designers" under the People tab