Rural Hunter wrote: > I encounter the same issue often: Granted update/insert to an user but > forgot to grant it on the related sequence. It's hard to understand that > an user has write access on table but not on necessary sequences. I > think the grant on tables should cascade to related sequences. What do > you think?
I think that would make sense. To me this seems related to the case where table B has a foreign key to table A with cascading delete or update. If a user has privileges on A, he or she can change values in B without having any privileges on B. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
