From: John Scalia <jayknowsunix@gmail.com>
To: Keith <keith@keithf4.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Strange inconsistency using psql
Date: Wed, 18 Dec 2019 13:35:11 -0500
Message-ID: <8C7A5C93-FBA2-49A7-AF59-1314585F67A0@gmail.com> (raw)
In-Reply-To: <CAHw75vt=iodvVhKb+EzGCwXBzG2og6bdMzQV7HJSeKw7meriow@mail.gmail.com>
References: <CAHw75vt=iodvVhKb+EzGCwXBzG2og6bdMzQV7HJSeKw7meriow@mail.gmail.com>
Correct, but my question really is, why is VIEW different from all the other types of objects? Shouldn’t the word VIEW also be an optional qualifier for the name of the object? Inconsistency strikes me as an oversight.
Sent from my iPad
> On Dec 18, 2019, at 12:41 PM, Keith <keith@keithf4.com> wrote:
>
>
>
>
>> On Wed, Dec 18, 2019 at 12:29 PM John Scalia <jayknowsunix@gmail.com> wrote:
>> I had to do some privilege assignments this morning on a bunch of tables, sequences, functions, and views. On all of these object, I generally try to use a command like:
>>
>> GRANT all ON TABLE x TO new_user;
>>
>> Where TABLE is either that object or a SEQUENCE or FUNCTION. These all worked perfectly for me. What did not work was specifying that the object was a VIEW. The system would spit out a syntax error at the object’s name being specified, however, if I omitted the word VIEW, and not specify the type of object, then the GRANT succeeded.
>>
>> Was this intentional behavior, or is the grammar slightly amiss? All the other types of objects worked perfectly with this style of command.
>> —
>> Jay
>>
>> Sent from my iPad
>>
>
> There is no VIEW clause to the GRANT command. The TABLE clause is actually optional in the command when setting privileges on tables or views. And generally you can use the privileges used on tables when setting privileges on views.
>
> https://www.postgresql.org/docs/current/sql-grant.html
>
> Keith
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, keith@keithf4.com
Subject: Re: Strange inconsistency using psql
In-Reply-To: <8C7A5C93-FBA2-49A7-AF59-1314585F67A0@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox