Richard Huxton wrote:
That's not a bug, it's a feature (as they say). I suppose you could
argue that a sequence only used by one table could inherit that
table's permissions by default, but I can see problems when people
reorder GRANT statements.

HTH

It's not feature, it's bug. From postgresql documentation 33.4. Rules and Privileges: <quote> Relations that are used due to rules get checked against the privileges of the rule owner, not the user invoking the rule. This means that a user only needs the required privileges for the tables/views that he names explicitly in his queries.</quote>

This dont' true for tables with serial fields.

--
Olleg Samoylov

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature



Reply via email to