| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: silly select question |
| Date: | 2003-02-05 17:21:23 |
| Message-ID: | 200302051720.20277.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2003-02-05 17:23:19 | Re: How start using schemas for existing database |
| Previous Message | Richard Huxton | 2003-02-05 17:15:13 | Re: Question: unique on multiple columns |