Dear All
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.
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!)
TAI
Hilary
Hilary Forbes
DMR Limited (UK registration 01134804)
A DMR Information and Technology Group company
(www.dmr.co.uk)
Direct tel 01689 889950 Fax 01689 860330
DMR is a UK registered trade mark of DMR Limited
**********************************************************