Re: information schema/aclexplode doesn't know about default privileges - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: information schema/aclexplode doesn't know about default privileges
Date
Msg-id 1326133439.12723.3.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: information schema/aclexplode doesn't know about default privileges  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: information schema/aclexplode doesn't know about default privileges  (Abhijit Menon-Sen <ams@toroid.org>)
Re: information schema/aclexplode doesn't know about default privileges  (Lionel Elie Mamane <lionel@mamane.lu>)
List pgsql-hackers
On mån, 2012-01-02 at 06:43 +0200, Peter Eisentraut wrote:
> I figured the best and most flexible way to address this is to export
> acldefault() as an SQL function and replace
>
>     aclexplode(proacl)
>
> with
>
>     aclexplode(coalesce(proacl, acldefault('f', proowner)))
>
> where 'f' here is something that is mapped to ACL_OBJECT_FUNCTION
> internally.  AFAICT, there is no existing way to map an SQL-accessible
> quantity to the ACL_OBJECT_* symbols, so I'll just have to make
> something up.

Nobody had a better idea, so here is the final patch.  I adjusted the
regression tests a bit to avoid bloat from the now-visible owner
privileges.

Attachment

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: pgindent README correction
Next
From: Robert Haas
Date:
Subject: Re: pgindent README correction