Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-29 Thread Oleksii Kliukin
On Tue, Jul 28, 2015 at 10:51 AM, Egor Rogov wrote: > > Well, I looked into a draft of SQL:2003. It basically says that "cascade" > for must behave the same way as for privilege statement>. That is, from standard's point of view we have a code > issue. > > Still I doubt about usefulness of this

Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-28 Thread Egor Rogov
On 27.07.2015 22:09, Stephen Frost wrote: * Egor Rogov (e.ro...@postgrespro.ru) wrote: On Thu, Jul 23, 2015 at 8:30 AM, Egor Rogov wrote: So, the question: is it a documentation bug (as it seems to me), code bug, or I missed something? Your analysis looks right to me, but I don't know whether

Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-27 Thread Stephen Frost
Egor, * Egor Rogov (e.ro...@postgrespro.ru) wrote: > >On Thu, Jul 23, 2015 at 8:30 AM, Egor Rogov wrote: > >>So, the question: is it a documentation bug (as it seems to me), code bug, > >>or I missed something? > >Your analysis looks right to me, but I don't know whether the code or > >the docume

Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-27 Thread Egor Rogov
On Thu, Jul 23, 2015 at 8:30 AM, Egor Rogov wrote: So, the question: is it a documentation bug (as it seems to me), code bug, or I missed something? Your analysis looks right to me, but I don't know whether the code or the documentation should be changed. This claim was added by Tom Lane in

Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-24 Thread Robert Haas
On Thu, Jul 23, 2015 at 8:30 AM, Egor Rogov wrote: > So, the question: is it a documentation bug (as it seems to me), code bug, > or I missed something? Your analysis looks right to me, but I don't know whether the code or the documentation should be changed. This claim was added by Tom Lane in

[HACKERS] Revoke [admin option for] role

2015-07-23 Thread Egor Rogov
Hi, I found an inconsistency between documentation and real behavior of REVOKE [ADMIN OPTION FOR] ROLE. As per documentation (http://www.postgresql.org/docs/current/static/sql-revoke.html): -- If GRANT OPTION FOR is specified, only the grant option for the privilege is revoked, not the priv

[HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-23 Thread Egor Rogov
Hi, I found an inconsistency between documentation and real behavior of REVOKE [ADMIN OPTION FOR] ROLE. As per documentation (http://www.postgresql.org/docs/9.4/static/sql-revoke.html): -- If GRANT OPTION FOR is specified, only the grant option for the privilege is revoked, not the privileg