0

I've created a postgres user 'tester' and allowed to readonly to a database A. This user has no permisssion on database B & C.

But when I do \l to list database. The database B and C are also listed. How can I only list database A and keep other databases hidden?

I'm facing this in pgadmin. I cannot edit in pgadmin. I need a way to hide those other database using access policy in postgres db.

2

There is no way to do that in PostgreSQL. Don't try to modify permissions on catalog tables, that is likely to break PostgreSQL, and will certainly break client tools like pgAdmin and psql.

1
  • Thanks for answering :)
    – Pax
    Nov 29 '21 at 8:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.