Using Nakama 3, postgres DB, and the Unity SDK, I’m calling AuthenticateDeviceAsync() with create == true, but getting response 500: error finding user account.
Looking at server logs, I see the DB denied access.
"caller": "server/core_authenticate.go:177", "msg": "Error looking up user by device ID.", "error": "ERROR: permission denied for relation user_device (SQLSTATE 42501)",
I haven’t changed any permissions (that I know of!).
I’m new to postgres and backend devops in general. I would expect the DB to be in a default state where it could perform these (seemingly?) basic operations. Any suggestions appreciated!