Hello, I use neo4j 4.2 enterprise on Ubuntu. My config:
dbms.security.procedures.unrestricted=jwt.security.,apoc.,gds.*
dbms.security.procedures.allowlist=jwt.security.,apoc.,gds.*
This cypher-statement works fine:
MERGE (p:Shipment) SET p.Start = timestamp()
gives: Set 1 property, completed after 76 ms.
But this gives an error:
< CALL apoc.cypher.run('MERGE (p:Shipment) SET p.Start = timestamp()', {}) />
gives: Set property for property 'Start' is not allowed for user 'neo4j' with roles [PUBLIC, admin] overridden by READ.
The query-log:
2020-11-30 08:15:44.553+0000 ERROR id:4 - 1260 ms: 0 B - bolt-session bolt neo4j-browser/v4.2.0 client/127.0.0.1:34322 server/127.0.0.1:7687> neo4j - crafter - MERGE (p:Shipment) SET p.Start = timestamp() - {} - runtime=slotted - {type: 'user-direct', app: 'neo4j-browser_v4.2.0'}
org.neo4j.graphdb.security.AuthorizationViolationException: Set property for property 'Start' is not allowed for user 'crafter' with roles [PUBLIC, admin] overridden by READ.
at org.neo4j.internal.kernel.api.security.AccessMode$Static.onViolation(AccessMode.java:289) ~[neo4j-kernel-api-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.api.security.WrappedAccessMode.onViolation(WrappedAccessMode.java:52) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.api.security.OverriddenAccessMode.onViolation(OverriddenAccessMode.java:33) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.newapi.Operations.assertAllowsSetProperty(Operations.java:1592) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.newapi.Operations.nodeSetProperty(Operations.java:611) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.TransactionBoundQueryContext$NodeOperations.setProperty(TransactionBoundQueryContext.scala:608) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.planning.ExceptionTranslatingQueryContext$ExceptionTranslatingOperations.setProperty(ExceptionTranslatingQueryContext.scala:366) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.UpdateCountingQueryContext$CountingOps.setProperty(UpdateCountingQueryContext.scala:232) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.pipes.AbstractSetPropertyOperation.setProperty(SetOperation.scala:88) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.pipes.SetEntityPropertyOperation.set(SetOperation.scala:108) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.pipes.SetPipe.$anonfun$internalCreateResults$1(SetPipe.scala:31) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.ClosingIterator$$anon$3.next(ClosingIterator.scala:153) ~[neo4j-cypher-runtime-util-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.pipes.EmptyResultPipe.internalCreateResults(EmptyResultPipe.scala:30) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.pipes.PipeWithSource.createResults(Pipe.scala:71) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.pipes.PipeWithSource.createResults(Pipe.scala:67) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.PipeExecutionResult.request(PipeExecutionResult.scala:63) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.StandardInternalExecutionResult.request(StandardInternalExecutionResult.scala:88) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.StandardInternalExecutionResult.initiate(StandardInternalExecutionResult.scala:51) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.ClosingExecutionResult.$anonfun$initiate$1(ClosingExecutionResult.scala:59) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) ~[scala-library-2.12.10.jar:?]
at org.neo4j.cypher.internal.result.ClosingExecutionResult.safely(ClosingExecutionResult.scala:100) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.ClosingExecutionResult.initiate(ClosingExecutionResult.scala:59) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.ClosingExecutionResult$.wrapAndInitiate(ClosingExecutionResult.scala:184) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.CypherCurrentCompiler$CypherExecutableQuery.innerExecute(CypherCurrentCompiler.scala:367) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.CypherCurrentCompiler$CypherExecutableQuery.execute(CypherCurrentCompiler.scala:305) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.ExecutionEngine.doExecute(ExecutionEngine.scala:222) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.ExecutionEngine.$anonfun$executeSubQuery$1(ExecutionEngine.scala:183) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.ExecutionEngine.closing(ExecutionEngine.scala:188) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.ExecutionEngine.executeSubQuery(ExecutionEngine.scala:180) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.ExecutionEngine.execute(ExecutionEngine.scala:130) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.javacompat.ExecutionEngine.executeQuery(ExecutionEngine.java:132) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.javacompat.ExecutionEngine.executeQuery(ExecutionEngine.java:120) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.coreapi.TransactionImpl.execute(TransactionImpl.java:235) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.coreapi.TransactionImpl.execute(TransactionImpl.java:224) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.procedure.impl.ProcedureTransactionProvider$ProcedureTransactionImpl.execute(ProcedureTransactionProvider.java:107) ~[neo4j-procedure-4.2.0.jar:4.2.0]
at apoc.cypher.Cypher.runCypherQuery(Cypher.java:81) ~[apoc-4.2.0.0.jar:4.2.0.0]
at apoc.cypher.Cypher.run(Cypher.java:76) ~[apoc-4.2.0.0.jar:4.2.0.0]
at org.neo4j.kernel.impl.proc.GeneratedProcedure_run49876029244246.apply(Unknown Source) ~[?:?]
at org.neo4j.procedure.impl.ProcedureRegistry.callProcedure(ProcedureRegistry.java:236) ~[neo4j-procedure-4.2.0.jar:4.2.0]
at org.neo4j.procedure.impl.GlobalProceduresRegistry.callProcedure(GlobalProceduresRegistry.java:364) ~[neo4j-procedure-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.newapi.AllStoreHolder.callProcedure(AllStoreHolder.java:946) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.kernel.impl.newapi.AllStoreHolder.procedureCallRead(AllStoreHolder.java:871) ~[neo4j-kernel-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.CallSupport$.$anonfun$callReadOnlyProcedure$1(CallSupport.scala:44) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.CallSupport$.callProcedure(CallSupport.scala:63) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.CallSupport$.callReadOnlyProcedure(CallSupport.scala:44) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.interpreted.TransactionBoundQueryContext.callReadOnlyProcedure(TransactionBoundQueryContext.scala:979) ~[neo4j-cypher-interpreted-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.planning.ExceptionTranslatingQueryContext.callReadOnlyProcedure(ExceptionTranslatingQueryContext.scala:240) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.LazyReadOnlyCallMode.callProcedure(ProcedureCallMode.scala:52) ~[neo4j-cypher-runtime-util-4.2.0.jar:4.2.0]
at org.neo4j.codegen.OperatorTaskPipeline0_1.compiledOperate(Unknown Source) ~[?:?]
at org.neo4j.cypher.internal.runtime.pipelined.operators.CompiledTask.operateWithProfile(OperatorCodeGenBaseTemplates.scala:342) ~[neo4j-cypher-pipelined-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.pipelined.PipelineTask.executeOperators(PipelineTask.scala:62) ~[neo4j-cypher-pipelined-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.pipelined.PipelineTask.executeWorkUnit(PipelineTask.scala:52) ~[neo4j-cypher-pipelined-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.pipelined.Worker.executeTask(Worker.scala:135) ~[neo4j-cypher-pipelined-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.pipelined.Worker.workOnQuery(Worker.scala:91) ~[neo4j-cypher-pipelined-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.runtime.pipelined.execution.CallingThreadExecutingQuery.request(CallingThreadExecutingQuery.scala:39) ~[neo4j-cypher-pipelined-runtime-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.PipelinedRuntime$PipelinedRuntimeResult.request(PipelinedRuntime.scala:437) ~[neo4j-enterprise-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.StandardInternalExecutionResult.request(StandardInternalExecutionResult.scala:88) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.cypher.internal.result.ClosingExecutionResult.request(ClosingExecutionResult.scala:145) ~[neo4j-cypher-4.2.0.jar:4.2.0]
at org.neo4j.fabric.stream.QuerySubject$BasicQuerySubject$1.doRequest(QuerySubject.java:184) ~[neo4j-fabric-4.2.0.jar:4.2.0]
at org.neo4j.fabric.stream.QuerySubject$BasicQuerySubject$1.request(QuerySubject.java:167) ~[neo4j-fabric-4.2.0.jar:4.2.0]
at reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:130) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:130) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:130) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:130) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:130) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.request(Operators.java:2116) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:130) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at reactor.core.publisher.StrictSubscriber.request(StrictSubscriber.java:138) ~[reactor-core-3.3.9.RELEASE.jar:3.3.9.RELEASE]
at org.neo4j.fabric.stream.Rx2SyncStream$RecordSubscriber.request(Rx2SyncStream.java:129) ~[neo4j-fabric-4.2.0.jar:4.2.0]
at org.neo4j.fabric.stream.Rx2SyncStream.maybeRequest(Rx2SyncStream.java:91) ~[neo4j-fabric-4.2.0.jar:4.2.0]
at org.neo4j.fabric.stream.Rx2SyncStream.readRecord(Rx2SyncStream.java:50) ~[neo4j-fabric-4.2.0.jar:4.2.0]
at org.neo4j.fabric.bolt.BoltQueryExecutionImpl$QueryExecutionImpl.request(BoltQueryExecutionImpl.java:179) ~[neo4j-fabric-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.AbstractCypherAdapterStream.handleRecords(AbstractCypherAdapterStream.java:104) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.v3.messaging.ResultHandler.onPullRecords(ResultHandler.java:41) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.v4.messaging.PullResultConsumer.consume(PullResultConsumer.java:42) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State.consumeResult(TransactionStateMachine.java:511) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State$2.streamResult(TransactionStateMachine.java:355) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.streamResult(TransactionStateMachine.java:94) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.v4.runtime.InTransactionState.processStreamResultMessage(InTransactionState.java:73) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.v4.runtime.AbstractStreamingState.processUnsafe(AbstractStreamingState.java:49) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.v4.runtime.InTransactionState.processUnsafe(InTransactionState.java:60) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.v3.runtime.FailSafeBoltStateMachineState.process(FailSafeBoltStateMachineState.java:48) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.nextState(AbstractBoltStateMachine.java:143) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.process(AbstractBoltStateMachine.java:91) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.messaging.BoltRequestMessageReader.lambda$doRead$1(BoltRequestMessageReader.java:90) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.DefaultBoltConnection.lambda$enqueue$0(DefaultBoltConnection.java:147) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatchInternal(DefaultBoltConnection.java:236) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:171) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:161) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:246) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$3(ExecutorBoltScheduler.java:229) ~[neo4j-bolt-4.2.0.jar:4.2.0]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [netty-all-4.1.53.Final.jar:4.1.53.Final]
at java.lang.Thread.run(Thread.java:834) [?:?]
Can you help me?