System catalog table privileges - Mailing list pgsql-sql

From Hilary Forbes
Subject System catalog table privileges
Date
Msg-id 5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk
Whole thread Raw
Responses Re: System catalog table privileges  ("Aaron Bono" <postgresql@aranya.com>)
Re: System catalog table privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Dear All<br /><br /> Next question on privileges!  Can I safely remove all privileges from the system catalog tables
fora user and still enable them to select from the public schema?  I guess the real question is what access rights does
anordinary user have to have to the system catalog tables in order for postgres to work properly given I only ever want
theuser to be able to SELECT from views.<br /><br /> This is all brought about by a user who wants to use MS Access
Queryfor adhoc queries to a (small) database via ODBC.  (the database itself drives a major web application.) I can't
findan easy way of preventing them seeing that tables exist but I don't want them trying to manually update any tables
ofmine 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 /><p> Hilary Forbes<br /> DMR Limited (UK registration 01134804) <br /> A DMR Information
andTechnology Group company (<a eudora="autourl" href="http://www.dmr.co.uk/"><font
color="#0000FF"><u>www.dmr.co.uk</u></font></a>)<br /> Direct tel 01689 889950 Fax 01689 860330 <br /> DMR is a UK
registeredtrade mark of DMR Limited<br /> ********************************************************** 

pgsql-sql by date:

Previous
From: Hilary Forbes
Date:
Subject: Re: Help with privilages please
Next
From: "Aaron Bono"
Date:
Subject: Re: System catalog table privileges