Re: document deviation from standard on REVOKE ROLE

2023-11-01 Thread Bruce Momjian
On Wed, Nov 1, 2023 at 07:49:25PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Fri, Oct 30, 2020 at 02:03:48PM -0400, John Naylor wrote: > >> +In the SQL standard, REVOKE only revokes the > >> privilege > >> +as granted by the invoking role. In > >> PostgreSQL, > >> +this w

Re: document deviation from standard on REVOKE ROLE

2023-11-01 Thread Tom Lane
Bruce Momjian writes: > On Fri, Oct 30, 2020 at 02:03:48PM -0400, John Naylor wrote: >> +In the SQL standard, REVOKE only revokes the >> privilege >> +as granted by the invoking role. In >> PostgreSQL, >> +this will also revoke privileges granted by other roles. > John, should this

Re: document deviation from standard on REVOKE ROLE

2023-11-01 Thread Bruce Momjian
On Fri, Oct 30, 2020 at 02:03:48PM -0400, John Naylor wrote: > This is the other doc fix as suggested in  > https://www.postgresql.org/message-id/20201027220555.GS4951%40momjian.us > > There is already a compatibility section, so put there. > --  > John Naylor > EnterpriseDB: http://www.enterprise

document deviation from standard on REVOKE ROLE

2020-10-30 Thread John Naylor
This is the other doc fix as suggested in https://www.postgresql.org/message-id/20201027220555.GS4951%40momjian.us There is already a compatibility section, so put there. -- John Naylor EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company v1-doc-fix-revoke-role.patch Desc