From: Hilary Forbes <hforbes@dmr.co.uk>
To: pgsql-sql@postgresql.org
Subject: System catalog table privileges
Date: Fri, 21 Jul 2006 13:45:16 +0100
Message-ID: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk> (raw)
<html>
Dear All<br><br>
Next question on privileges! Can I safely remove all privileges
from the system catalog tables for a user and still enable them to select
from the public schema? I guess the real question is what access
rights does an ordinary user have to have to the system catalog tables in
order for postgres to work properly given I only ever want the user to be
able to SELECT from views.<br><br>
This is all brought about by a user who wants to use MS Access Query for
adhoc queries to a (small) database via ODBC. (the database itself
drives a major web application.) I can't find an easy way of preventing
them seeing that tables exist but I don't want them trying to manually
update any tables of mine or postgres's thank you very much! (Don't
shoot the messenger - there's no accounting for user's tastes!)<br><br>
TAI<br>
Hilary<br>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
DMR Limited (UK registration 01134804) <br>
A DMR Information and Technology Group company
(<a href="http://www.dmr.co.uk/"; eudora="autourl"><font color="#0000FF"><u>www.dmr.co.uk</a></u></font>)
<br>
Direct tel 01689 889950 Fax 01689 860330 <br>
DMR is a UK registered trade mark of DMR Limited<br>
**********************************************************</html>
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: hforbes@dmr.co.uk
Subject: Re: System catalog table privileges
In-Reply-To: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk>
* 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