Discussion:
Restrictions for system tables
(too old to reply)
m***@mikrobit.pl
2004-09-16 14:14:43 UTC
Permalink
Hi I have many databases in Postgresql and I want to have one user who can
connect only to one database but now if he querying pg_database (select * from
pg_database) he gets list of all databases in my postgres.
Is there any chanse to restrict access to pg_database, which gives in result of
querying pg_database only database which is owned by my restricted user?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org
Peter Eisentraut
2004-09-18 14:02:32 UTC
Permalink
Post by m***@mikrobit.pl
Is there any chanse to restrict access to pg_database, which gives in
result of querying pg_database only database which is owned by my
restricted user?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org
Loading...