Обсуждение: silly select question

Running PostgreSQL 7.2.1 on RedHat Linux 7.2

This may seem like an obviously stupid question, but
is there any other reason, besides security
issues, that the system tables (pg_shadow, for one)
does not have select access on it?

Thanks!

-X

On Wednesday 05 Feb 2003 2:45 pm, Johnson, Shaunn wrote:
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2
>
> This may seem like an obviously stupid question, but
> is there any other reason, besides security
> issues, that the system tables (pg_shadow, for one)
> does not have select access on it?

Most system tables *do* have select access, otherwise you couldn't see what
tables, views, functions etc. existed.

Now pg_shadow is special, because it contains the passwords PG uses, so only
the administrator (user postgres) should be able to see that.

--
  Richard Huxton