On Monday, March 31, 2025, PG Doc comments form <nore...@postgresql.org> wrote:
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/sql-grant.html > Description: > > The documentation indicates that they keyword SEQUENCE must precede the > sequence_name in a GRANT, but in my experience it is optional: > > colin@adinkra:~$ psql > psql (17.4 (Debian 17.4-1.pgdg120+2)) > Type "help" for help. > > colin@[local]:colin=> create sequence x; > CREATE SEQUENCE > colin@[local]:colin=> grant select on x to public; -- should fail but > works > > Sequences are relations (see pg_class) so the [TABLE] variant is able to target them, which is what you’ve written here. David J.
