I'm trying to cram three different organisations into one server. Today they each have their own geoserver instance connected to separate PostGIS databases, which works fine. But now they also need to be able to access and manipulate their own data and I can't figure out how to set this up.
So in short: How do I set up three different users in PostGIS and grant them access to one specific database each?
Any suggestions welcome