Re: GRANT ON ALL IN schema

> Something like
> DO $$ begin ...; end $$;
> 
> gives 90% of the usability with 10% of the trouble.

I'd be a big fan of this.  Especially if we could at an \e for it in
psql.  \ec?

I'm not agreeing, though, that we don't need a GRANT ALL/ALTER DEFAULT.We still need that for the simplest cases so
thatnovice-level users
 
will use *some* access control.  But it would mean that we wouldn't need
GRANT ALL/ALTER DEFAULT to support anything other than the simplest cases.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com