Re: Permissions for system tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Permissions for system tables
Date
Msg-id 22737.1030371065@sss.pgh.pa.us
Whole thread Raw
In response to Permissions for system tables  (Richard Ray <rray1@netdoor.com>)
Responses Re: Permissions for system tables  (Richard Ray <rray1@netdoor.com>)
List pgsql-general
Richard Ray <rray1@netdoor.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

pgsql-general by date:

Previous
From: Richard Ray
Date:
Subject: Permissions for system tables
Next
From: Patrick FICHE
Date:
Subject: Problem with date calculation