Thread: TRUNCATE privilege vs information_schema

TRUNCATE privilege vs information_schema

From
Tom Lane
Date:
Whilst going through the pending patch to add TRUNCATE as a separate
permission, I noticed that it neglected to add TRUNCATE to the various
columns in information_schema that display privileges.  I wonder whether
we should do so, or whether we should restrict information_schema to
only show SQL-spec-compatible privileges.
        regards, tom lane


Re: TRUNCATE privilege vs information_schema

From
"Dave Page"
Date:
On Sun, Sep 7, 2008 at 9:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Whilst going through the pending patch to add TRUNCATE as a separate
> permission, I noticed that it neglected to add TRUNCATE to the various
> columns in information_schema that display privileges.  I wonder whether
> we should do so, or whether we should restrict information_schema to
> only show SQL-spec-compatible privileges.

If we add that, how many other places are we likely to creep from the
spec in the future? I think we should keep it as spec-compliant as
possible.

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com