Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM PUBLIC; > > REVOKE > > r=# GRANT ALL ON FUNCTION weekdate (date) TO PUBLIC; > > GRANT > > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM rbt; > > ERROR: dependent privileges exist > > HINT: Use CASCADE to revoke them too. > > Ugh. We could fix pg_dump to output the commands in a better order, > but that won't help for dumps from existing releases. > > Given that rbt is the owner of the object, I'm not sure that it is > sensible to interpret the above as revoking his ability to grant > privileges to others. Seems to me that his ability to GRANT is inherent > in being the owner, and as such his "grant option" bits are irrelevant. > So maybe the commands are okay and the backend's interpretation is > bogus. > > Peter, any thoughts?
Has this been resolved? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
