From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hilary Forbes <hforbes@dmr.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: System catalog table privileges
Date: Fri, 21 Jul 2006 10:47:08 -0400
Message-ID: <22470.1153493228@sss.pgh.pa.us> (raw)
In-Reply-To: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk>
References: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk>
Hilary Forbes <hforbes@dmr.co.uk> writes:
> Next question on privileges! Can I safely remove all privileges
> from the system catalog tables for a user
Various people have experimented with doing that, but it tends to break
a lot of stuff. I suggest you just revoke privileges on the tables you
don't want the users messing with, and not get too worried about whether
they know the tables exist or not.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, hforbes@dmr.co.uk
Subject: Re: System catalog table privileges
In-Reply-To: <22470.1153493228@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox