restrict column-level GRANTs to a single relation?

From: kevin brintnall <kbrint(at)rufus(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: restrict column-level GRANTs to a single relation?
Date: 2006-01-19 08:50:14
Message-ID: 20060119085013.GA43061@rufus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fellow hackers,

I'm curious about the best way to handle something like this:

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? That would require the preceding
grant to be specified as:

GRANT SELECT (col1, col2, col3) ON table1 TO grantee;
GRANT SELECT (col1, col2, col3) ON table2 TO grantee;

The SQL standards don't seem to mandate the first form (unless I
misread?).. Do y'all think this is a reasonable compromise?

--
kevin brintnall =~ <kbrint(at)rufus(dot)net>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2006-01-19 08:50:52 Re: Surrogate keys (Was: enums)
Previous Message Leandro Guimarães Faria Corcete Dutra 2006-01-19 08:23:16 Re: Surrogate keys (Was: enums)