Re: AW: Proposal for enhancements of privilege system

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