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