kevin brintnall <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly