Re: Permissions for system tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Ray <rray1(at)netdoor(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Permissions for system tables
Date: 2002-08-26 14:11:05
Message-ID: 22737.1030371065@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Ray <rray1(at)netdoor(dot)com> writes:
> How can I determine the permissions for system tables?

The default permissions for system catalogs are world read, other
privileges for owner (postgres) only.

You can try restricting the world read if you like, but be advised
that it's likely to break clients that expect to be able to inspect
the system catalogs.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick FICHE 2002-08-26 15:29:51 Problem with date calculation
Previous Message Richard Ray 2002-08-26 14:01:25 Permissions for system tables