cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

Permission issue when writing/updating with apoc.periodic.iterate

I am connecting through bolt protocol to a Neo4j Server instance.
When using apoc.periodic.iterate to set a property (calling apoc.ttl.expire), I get errors like this:

"org.neo4j.graphdb.QueryExecutionException: Set property for property 'ttl' on database 'neo4j' is not allowed for user 'andrea' with roles [PUBLIC, admin] overridden by TOKEN_WRITE overridden by READ."

Why is that if I should be assigned an admin role? Why do those final "overridden by.." occur?

Thanks

4 REPLIES 4

song
Node Link

Hi Andrea,
I encountered the same issue😢, Did you solve this problem? 

Cobra
Ninja
Ninja

Hello @andrea_bucci and @song 🙂

Can you share the query, the database version and the APOC version?

Regards,

Cobra

wadael
Node Clone

Hello,
Something similar here, when doing a MERGE in apoc.when

LOAD CSV WITH HEADERS FROM 'file:///Faulty.csv' AS line
CALL apoc.when(line.town IS NOT NULL,
"MERGE (v:Ville {name: line.town, height: line.height})",
"",{line: line}
) YIELD value
RETURN value
Create node with labels 'Ville' on database 'neo4j' is not allowed for user 'neo4j' with roles [PUBLIC, admin] overridden by READ.




Unfortunately, I found no apoc specific setting that could solve it
https://github.com/neo4j-contrib/neo4j-apoc-procedures/blob/071eb592a6afe26840219e3fe00e20fda56b36e1...

And I have no idea why roles/auths seems to be applied in reverse

wadael
Node Clone