Re: grant and SQL92

Vince Vielhaber writes:

> I can grant a series of privileges (comma separated) on a series of
> objects (comma separated) to either a user, group or public NOT a
> comma separated list of users or groups. Yet at the bottom of the
> man page for grant
>
> http://www.postgresql.org/idocs/index.php?sql-grant.html
>
> it says it's allowed in SQL92. How is it this isn't allowed in
> postgresql, is it a real pain to implement or was it just never
> needed?

There is insufficient internal representation of the GRANT parse tree,
which makes this cumbersome to implement. Not terribly hard to fix, but
someone needs to do it. (Where were those PostgreSQL hacker newbies?)

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter