TRUNCATE privilege vs information_schema
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
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