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

From Richard Ray
Subject Re: Permissions for system tables
Date
Msg-id 200208271929.g7RJT0s21712@rray.mstc.state.ms.us
Whole thread Raw
In response to Re: Permissions for system tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I don't want to change anything. I'm just learn'n.
Is there somewhere I can lookup the assignment for system tables and views?

On Monday 26 August 2002 09:11 am, you wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: stupid Q regarding "UPDATE waiting"
Next
From: C F
Date:
Subject: Re: Limiting User Resources