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@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
