On Tue, Jun 28, 2005 at 14:52:07 -0500, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Tue, Jun 28, 2005 at 14:45:06 -0400, > Stephen Frost <[EMAIL PROTECTED]> wrote: > > > > If you are the owner of the object to be changed (following the normal > > owner checking rules) AND would still be considered the owner of the > > object *after* the change, then you can change the ownership. > > That still isn't a good idea, because the new owner may not have had > access to create the object you just gave to them. Or you may not have > had access to drop the object you just gave away. That is going to > be a security hole.
Thinking about it some more, drops wouldn't be an issue since the owner can always drop objects. Creating objects in particular schemas or databases is not something that all roles may be able to do. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly