From: | Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Revoke access on pg_user |
Date: | 2003-09-03 08:58:36 |
Message-ID: | 200309030858.h838waxI043954@lurza.secnetix.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
By default, all users can find out what other users exist,
by looking at pg_user (which is a view on pg_shadow). For
privacy reasons I would like to disable that.
So I tried this: REVOKE ALL ON pg_user FROM PUBLIC;
which was acknowledged by the word "REVOKE", and there was
no error message. But it doesn't have any effect. All
users can still perform SELECT on pg_user and see everyone.
What am I doing wrong?
Regards
Oliver
PS: I'm using 7.3.4 on FreeBSD 4.8, if that matters.
PPS: I apologize if this post appears twice (I first
mailed it with the wrong subscription address.)
--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.
"C++ is the only current language making COBOL look good."
-- Bertrand Meyer
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-03 13:51:06 | Re: Revoke access on pg_user |
Previous Message | Tomka Gergely | 2003-09-03 06:30:09 | Re: Using COPY |