Revoke access on pg_user - Mailing list pgsql-novice

From Oliver Fromme
Subject Revoke access on pg_user
Date
Msg-id 200309021554.h82FsDxR010346@lurza.secnetix.de
Whole thread Raw
List 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.

--
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

pgsql-novice by date:

Previous
From: "Tyler Colbert"
Date:
Subject: Re: using dates in pgsql
Next
From: Nabil Sayegh
Date:
Subject: Re: ORDER BY question