Re: Permissions for system tables

From: Richard Ray <rray1(at)netdoor(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Permissions for system tables
Date: 2002-08-27 19:29:00
Message-ID: 200208271929.g7RJT0s21712@rray.mstc.state.ms.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Browse pgsql-general by date

  From Date Subject
Next Message C F 2002-08-27 19:36:22 Re: Limiting User Resources
Previous Message Andrew Sullivan 2002-08-27 18:08:17 Re: stupid Q regarding "UPDATE waiting"