| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
| Cc: | "'PostgreSQL Development'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: AW: Proposal for enhancements of privilege system |
| Date: | 2000-05-30 11:49:40 |
| Message-ID: | Pine.GSO.4.02A.10005301347380.10362-100000@Leopard.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 30 May 2000, Zeugswetter Andreas SB wrote:
> Of course the grant revoke is the same. But administrative tools
> usually allow you to dump schema, all rights, triggers ... for an
> object and thus need access to the system tables containing the
> grants.
That's what you use the information schema views for. Also, of course,
we're light years away from having anything like a portable pg_dump.
> Imho this is an area that is extremly sensitive to performance, the
> rights have to be checked for each access.
But using some sort of arrays is going to make it slower in any case since
you can't use indexes on those.
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff MacDonald | 2000-05-30 12:28:11 | 7.0 weirdness |
| Previous Message | Karel Zak | 2000-05-30 11:46:09 | Re: AW: Proposal for enhancements of privilege system |