I am completely new to the game but need the following:
I Create a new role with login. Let's say: User1
I then create a Database 'User1Database' and set User1 as the owner.
User1 has no rights to do anything except for access.
Now when I connect using User1 it somehow has access to all databases. I then learned I neeed to write something in here.
User1 should have global access to User1Database and absolutely no access to anything else.
What lines do I need to add to my pg_hba file?
Currently it looks like this:
# IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 host all all 0.0.0.0/0 md5
Hope someone can write me the exact lines and explain them to me.