Strange inconsistency using psql

John Scalia <[email protected]> Wed, 18 Dec 2019 12:28:46 -0500
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <[email protected]>
I had to do some privilege assignments this morning on a bunch of tables, se=
quences, functions, and views. On all of these object, I generally try to us=
e a command like:

GRANT all ON TABLE x TO new_user;

Where TABLE is either that object or a SEQUENCE or FUNCTION. These all worke=
d perfectly for me. What did not work was specifying that the object was a V=
IEW. The system would spit out a syntax error at the object=E2=80=99s name b=
eing specified, however, if I omitted the word VIEW, and not specify the typ=
e of object, then the GRANT succeeded.

Was this intentional behavior, or is the grammar slightly amiss? All the oth=
er types of objects worked perfectly with this style of command.
=E2=80=94
Jay

Sent from my iPad=