Re: [HACKERS] [COMMITTERS] pgsql-server/src/backend/catalog aclchk.c

2003-10-06 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> But I wonder how this squares with the SQL spec... > The root of this problem is that revoking privileges from the owner > doesn't square with the SQL spec in the first place. Allowing having a > grant option without the privilege

Re: [HACKERS] [COMMITTERS] pgsql-server/src/backend/catalog aclchk.c

2003-10-05 Thread Peter Eisentraut
Tom Lane writes: > So an owner can never revoke his own grant options? That seems > reasonable offhand, and compatible with our previous notion that > the owner's ability to GRANT was inherent and nonrevocable. > > But I wonder how this squares with the SQL spec... The root of this problem is th

Re: [HACKERS] [COMMITTERS] pgsql-server/src/backend/catalog aclchk.c

2003-10-05 Thread Tom Lane
[EMAIL PROTECTED] (Peter Eisentraut - PostgreSQL) writes: > When revoking privileges from the owner, don't revoke the grant options, > to avoid recursively revoking everything from everyone. So an owner can never revoke his own grant options? That seems reasonable offhand, and compati