table_privileges view always show object owner as a grantor

2019-03-29 Thread Ashutosh Sharma
Hi All, I noticed that irrespective of whoever grants privileges on an object, it's always the object owner who is seen as a grantor in the output of table_privileges view. As an example, consider the following case. create user u1; create user u2 with superuser; create user u3; \c postgres u1 c

Re: table_privileges view always show object owner as a grantor

2019-03-29 Thread Laurenz Albe
Ashutosh Sharma wrote: > I noticed that irrespective of whoever grants privileges on an object, > it's always the object owner who is seen as a grantor in the output of > table_privileges view. > Isn't that a wrong information ? If > incase that isn't wrong then may i k

Re: table_privileges view always show object owner as a grantor

2019-03-29 Thread Tom Lane
Laurenz Albe writes: > Ashutosh Sharma wrote: >> I noticed that irrespective of whoever grants privileges on an object, >> it's always the object owner who is seen as a grantor in the output of >> table_privileges view. The above is demonstrably false ... regression=# create user alice; CREATE R

Re: table_privileges view always show object owner as a grantor

2019-03-29 Thread Ashutosh Sharma
On Fri, Mar 29, 2019 at 8:15 PM Tom Lane wrote: > > Laurenz Albe writes: > > Ashutosh Sharma wrote: > >> I noticed that irrespective of whoever grants privileges on an object, > >> it's always the object owner who is seen as a grantor in the output of > >> table_privileges view. > > The above is