Stephen Frost <[EMAIL PROTECTED]> writes:
> iirc, the suggestion was to exclude the non-SQL-spec things from 'GRANT
> ALL' to avoid just that issue.  Having to grant TRUNCATE and/or DDL
> operation permissions explicitly would be reasonable.  This might create
> a disconnect with what 'revoke all' does, since that should really
> remove all of the perms, but I feel that's reasonable.  A 'Default
> secure' approach.

More like "default impossibly confusing" :-(.  "GRANT ALL" doesn't mean
grant all privileges?  How the heck are you going to explain/justify
that to a newbie?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to