TRUNCATE privilege vs information_schema

Started by Tom Laneover 17 years ago2 messageshackers
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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

#2Dave Page
dpage@pgadmin.org
In reply to: Tom Lane (#1)
Re: TRUNCATE privilege vs information_schema

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