deny access to system tables

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: deny access to system tables
Date: 2002-10-09 21:59:41
Message-ID: 1034200781.11704.93.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've created a user "dblackey" and given them select permissions (no
insert, update, etc...) on a couple of tables in my database. This
prevents them from selecting from arbitrary tables, but is there any way
to deny them select access to the system tables? REVOKE ALL ON pg_proc
FROM dblackey doesn't seem to work...

Robert Treat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herbie Liechti 2002-10-09 22:57:04 Re: odbc with debian woody/postgres
Previous Message Felipe Schnack 2002-10-09 21:25:14 md4