Permissions for system tables

От:

Richard Ray <rray1@netdoor.com>

Дата:

26 августа 2002 г. в 10:03:07


How can I determine the permissions for system tables?
It seems any user I create has access.
psql \z only shows permissions for user tables.
I checked relacl in pg_class but it's blank for all but user tables.

Thanks
Richard

Re: Permissions for system tables

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

26 августа 2002 г. в 10:11:45

Richard Ray  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

Re: Permissions for system tables

От:

Richard Ray <rray1@netdoor.com>

Дата:

27 августа 2002 г. в 15:30:48


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  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