Postgresql, hide database from listing

postgresql

I'm have a problem.
On my server i have many users.
I want to each user can see only database to what have access.

This is possible?
How to solve this problem?

Thanks for help

Best Answer

This is not possible on the database layer (i.e. on psql), AFAIK. pgAdmin added a custom functionality to hide inaccessible databases, but this is nothing more than a custom SELECT .. WHERE query to keep the list of databases short.

Related Solutions

Postgresql – How to tables be hidden from a user in PostgreSQL 8.1

I think the solution revolves around this simple question, is the one table that the Windows system needs access to part of an existing system that other applications need access to? Or is it a separate table that is only used by the Windows app?

If it's the latter a new schema with just that one table would indeed seem to be the answer.

If it's the former, permissions are the key. Create a new user that the Windows app will connect as, and then only grant access to that one table to that user. See: http://www.postgresql.org/docs/8.4/static/privileges.html

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

OK, got it from someone else. This query should do the trick:

select *
from pg_stat_activity
where datname = 'mydatabasename';

Best Answer

Related Solutions

Postgresql – How to tables be hidden from a user in PostgreSQL 8.1

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

Related Topic