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.

1 Answer 1

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 :)
    – PaxPrz
    Commented Nov 29, 2021 at 8:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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