From: | Christian Rank <christian(dot)rank(at)rz(dot)uni-passau(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | isolating users from each other |
Date: | 2004-02-02 12:12:44 |
Message-ID: | 401E3EBC.2090908@rz.uni-passau.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I'm setting up a PostgreSQL installation accessible by many different
users. The layout is:
- all users connect to the same database
- every user has its own schema, no write access to the public schema
- by default no additional privileges for the users
Thus, a user cannot access the data (e. g. contents of a table) of
another user. But a user can see all metadata (names of objects, layout
of tables, definitions of views, ...) of all other users. Is there any
possibility to restrict access to other users metadata? (I tried to
revoke access privileges on the pg_catalog schema, but then a user can
no longer access his own metadata ...)
Thanks in advance,
Christian
--
Dr. Christian Rank
Rechenzentrum Universität Passau
Innstr. 33
D-94032 Passau
GERMANY
Tel.: 0851/509-1838
Fax: 0851/509-1802
PGP public key see http://www.rz.uni-passau.de/mitarbeiter/rank
From | Date | Subject | |
---|---|---|---|
Next Message | Remi | 2004-02-02 14:03:46 | Postgresql 7.3 And Redhat Enterprise 3 |
Previous Message | Stephen Robert Norris | 2004-02-02 11:42:42 | Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 |