This content has been marked as final.
Show 3 replies
-
1. Re: Use Privs for Oracle
cpob Aug 8, 2006 2:06 PM (in response to michaelholtzman)Have you tried running without dba permission?
Off the top of my head, as long as it has rights to select/insert/update/delete you should be fine. -
2. Re: Use Privs for Oracle
michaelholtzman Aug 8, 2006 2:36 PM (in response to michaelholtzman)My thoughts exactly, except that without the dba role I get this error when launching a process instance:
14:31:22,644 ERROR JDBCExceptionReporter : ORA-00942: table or view does not exist 14:31:22,659 ERROR ProcessCommand : WORKFLOW_JBPM_LAUNCH_PROCESS couldn't assign id to org.jbpm.graph.exe.ProcessInstance@d2efa1
I get other assorted database errors when attempting other operations, e.g. deploying a definition:14:35:32,191 ERROR ProcessCommand : Unable to deploy process definition Process definition "Sample Workflow" deployment failed - could not get next sequence value
If I grant dba to the role I have assigned to the login user id, everything is happy again. -
3. Re: Use Privs for Oracle
cpob Aug 8, 2006 3:23 PM (in response to michaelholtzman)Oh, I think that is depending on your sequencer. Doesn't look like you're able to update the ID, there's gotta be a missing permission somewhere