Thread: Grant tables cascade to sequence?

Hi,

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?

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