Revoke access on pg_user
От | Oliver Fromme |
---|---|
Тема | Revoke access on pg_user |
Дата | |
Msg-id | 200309030858.h838waxI043954@lurza.secnetix.de обсуждение исходный текст |
Ответы |
Re: Revoke access on pg_user
|
Список | 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
В списке pgsql-novice по дате отправления: