Setting Home databases

[MarkMWright]

I don't seem to be able to set a home database for new users. I create a database "adam". If I then create a user with:
CREATE USER adam SET PASSWORD 'password' SET HOME DATABASE adam
then the SHOW USERS command says home is "null". If I then try to set the home database with:
ALTER USER adam SET HOME DATABASE adam
I get an error:

ERROR Neo.DatabaseError.General.UnknownError
No dependency satisfies type class org.neo4j.server.security.systemgraph.UserSecurityGraphComponent

What am I doing wrong?

[MarkMWright]

I also seem to have run into a bug of some kind - the following command does not work if the database doesn't exist:
CREATE OR REPLACE DATABASE test1
The error is:
Neo.DatabaseError.Statement.ExecutionFailed Database not found: 'test1'.
It looks like "OR REPLACE" isn't being interpreted?

[jmsuhy]

This looks like a bug - with the 'OR replace' logic.

Can you confirm which should happen when you use or replace?

IE - when using Neo4j enterprise - if there's already an existing database, does it back it up and create a new empty one when you use the 'or replace' part?

[MarkMWright]

I don't have Neo4j enterprise so cannot test that, sorry.

[PerWiklander]

According to the Enterprise docs, OR REPlACE is the the same as DROP IF EXISTS then CREATE.

See: https://neo4j.com/docs/operations-manual/current/database-administration/standard-databases/create-databases/

Do you plan on being 100% syntax compatible with Enterprise, or just have similar features?

[jmsuhy]

You’re not doing anything wrong, this issue is on our side. The method for setting a user’s home database hasn’t been implemented yet in our plugin.

Our initial focus was on getting the core enterprise features like multi-database support up and running, and we planned to circle back to implement the remaining methods like this one.

Now that this is on our radar, we’ll use this ticket to track and implement the missing functionality.

Once it’s in place, the SET HOME DATABASE command should start working as expected.

We’ll update this thread when the fixes are ready, thanks again for flagging it!