* Peter Eisentraut (peter_e@gmx.net) wrote:
> "I will produce a generic 'permission denied' error, and if the reason
> for the lack of permission is anything other than GRANT/REVOKE, then I
> will add it to the detail message."
That's what I had been thinking, on the assumption that individuals with
SQL-spec-type systems would be familiar with the GRANT/REVOKE system,
but..
> Seeing that we are planning to add more permissions systems of various
> kinds, I don't think it would be bad to uniformly add "You must have
> SELECT rights on relation X to SELECT from it" detail messages. The
> proposed changes would then be subset of that.
I'd be fine with that. It would mean an extra line of output in many
cases but we could at least be consistent across the backend with regard
to how these cases are handled...
Thanks!
Stephen