https://linen.dev logo
I can see a bunch of other databases when connecti...
# help
w
I am trying to add a new schema to my postgress db setup by shuttle when following the url shortener example. I connected using the properties in the attached image. However there is lots of databases visible which I am assuming are other peoples projects, how can I set it to just show my project and how can I make sure nobody else can edit my stuff? My project name is
codebin
.
s
Hmm, this is interesting 🤔 Are you able to view the content of those DBs by any change?
w
No, I only have permissions for my own db
I can view the schemas / tables but not content and cant edit
g
😳
s
Ahh, apparently we still have to harden the shared PG DB and they other DB names have always shown up. My client just never showed them so I was never aware of this. PG leaking information seems to be a quite common limitation, but I think there might still be a few settings we can tweak to improve this. Btw, the RDS DBs give you complete isolation (ie they aren't shared among projects) https://docs.shuttle.rs/resources/shuttle-aws-rds