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=