Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihd83-00072S-DL for pgsql-admin@arkaria.postgresql.org; Wed, 18 Dec 2019 17:28:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ihd82-00082J-49 for pgsql-admin@arkaria.postgresql.org; Wed, 18 Dec 2019 17:28:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihd81-0007yt-QM for pgsql-admin@lists.postgresql.org; Wed, 18 Dec 2019 17:28:53 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ihd7z-0002Fu-Du for pgsql-admin@postgresql.org; Wed, 18 Dec 2019 17:28:53 +0000 Received: by mail-qv1-xf33.google.com with SMTP id dc14so1054554qvb.9 for ; Wed, 18 Dec 2019 09:28:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:date:subject:message-id :to; bh=JBJpIyiJxbkceaFbgH549sbXaeg+dBQyhD4UgKfLtSA=; b=Vh43643sKPxGHPFa1J+51P4IeSptockYWKzsHDpbsfNy5yFp9t6FWpX5h34CIbiGjv XVF/aXZBPNpRc7v0BnFYW1ZTY09JJwJ1Vpaj/bMYkjIvP4R4GpDncFwUzc2rJWw/Dub5 ysUVJiYNEy53cynoRPmSanVzxoShrCpgI5BxbS7aUMPUQHZMomIcVgjM1nM22b+kpcVk vebChD6trvsdcsO+2/gFj1uW1tJCilmM2WlvPJzXjFxcdsyeU6+WU+MbOnT1XGTJAlTH msQdtud/ynXbo9H/2iX7PdzfsZwcu7fZ9P8qcdOvG9xrtJLPi3M2s/AERfhmu+TRRhf4 lNRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version:date :subject:message-id:to; bh=JBJpIyiJxbkceaFbgH549sbXaeg+dBQyhD4UgKfLtSA=; b=OOi8QEWTFGUTulg6Y2Nr4vl7LTSEOz4PaqzuW17x5nypfSOeP//wtc2Nf9fdjWgslN xcoR5hkk/cJb9SXCnVk6350BgQn6TOo3OY3Qu5sDeoJVXT33G4O7c8rH0kL0taGK/WLM qptIr+kA6sfWMo1vFdGiH9MVBtsYNELGgm6zDAKZxb5h8t2FQd4iwbjAjRwCg2U4CZX6 9tdKqaHu6XZPEkQOhutgl+zNSBHB4WkDnrfbaUllL52SZw01DYBEZD2Uu1LcSgrOnmCQ XjWpXP8ShCEQhkQ/Pghh9FBMPKAY2dQz/QTlCT0sOnt+HMTx40JgONUHNstEoCQ/IomN owkw== X-Gm-Message-State: APjAAAU3IUp3Js5BAzVwrwQaIsETq+owmO2ebMR2gIBoFU+y0uQUuq5t 1yhMOtSJfAyPjzKhSC0UdkE4z8Rw X-Google-Smtp-Source: APXvYqwVuEcMOwLW2euoexY1F9VCg/HBC4d1PNbFIilp0VgOOFOk0F+2i9oAxJ/+B4uN7reDUawtHQ== X-Received: by 2002:a05:6214:4f0:: with SMTP id cl16mr3463832qvb.213.1576690128799; Wed, 18 Dec 2019 09:28:48 -0800 (PST) Received: from [172.17.53.230] (rouge-137-188-108-19.vzw.com. [137.188.108.19]) by smtp.gmail.com with ESMTPSA id n7sm835341qke.121.2019.12.18.09.28.48 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 18 Dec 2019 09:28:48 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Date: Wed, 18 Dec 2019 12:28:46 -0500 Subject: Strange inconsistency using psql Message-Id: <2A39B85B-54CC-485B-9722-FCA13396E271@gmail.com> To: Pgsql-admin X-Mailer: iPad Mail (17C54) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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=