PostgreSQL sees foreign databases - is this normal?

Question

PostgreSQL

The guys installed PostgresSQL and phpPgAdmin, made several users and created databases for them, but each user sees someone else's database, is this normal?

Each database belongs to its user
It seems to me that no, I roamed and did not find anything about this. Can anyone say late?

Answer 1

If you need to separate the visibility of databases by users, then this is not correct.
you have created databases visible to everyone (I can’t say about grants because I don’t see them.
If you need to create databases and lock users in them, then use 2 commands

CREATE ROLE имя_пользователя WITH LOGIN PASSWORD 'пароль';
CREATE DATABASE имя_базы WITH OWNER Имя_пользователя;

To correct the situation now, use Revoke
Read more on Revoke
Give a specific user access to the database using Grant
More about GRANT

Answer 2

If you can take data from there, or even worse, write it down, etc. - you need to look at the access rights settings.

Answer 3

> The guys installed PostgresSQL and phpPgAdmin, created several users and created databases for them, but each user sees someone else's database, is this normal?
You are the database administrator. The database works the way YOU set it up. You specify what you want - if you want everyone to see other people's bases - then you did everything right and that's fine. If you want everyone to see only their database, then this is not normal, and you have not configured access rights.

Answer 4

It's not normal, I think.
This means that other users or a group of these users have read rights.

Answer 5

select * from pg_catalog.pg_roles;
field "rolsuper" for all users "t"?