Re: restrict column-level GRANTs to a single relation? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: restrict column-level GRANTs to a single relation?
Date
Msg-id 16268.1137683682@sss.pgh.pa.us
Whole thread Raw
In response to restrict column-level GRANTs to a single relation?  (kevin brintnall <kbrint@rufus.net>)
List pgsql-hackers
kevin brintnall <kbrint@rufus.net> writes:
>     GRANT SELECT (col1, col2, col3) ON table1, table2 TO grantee;

> Is it reasonable to restrict this to a single relation, and throw an error
> if multiple relations are specified?

The SQL spec doesn't actually allow multiple things after GRANT ... ON
--- that's a PG extension.  So you could make the restriction and not
violate the spec.  OTOH it seems unlikely that this would save much.
        regards, tom lane


pgsql-hackers by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: Surrogate keys (Was: enums)
Next
From: "Jim C. Nasby"
Date:
Subject: Re: No heap lookups on index