Thread: Changing owner objects
Hi, Is there an easy way (in one go) to change the owner of all database objects with PG Admin ? I am creating a schema with a script that assign the objects owner to login (I mean conection role) A . Then I switch the schema owner to login (/conection role) B. But the objects are still owned by A. Is there an easy way in PG Admin to change the owner obejcts from A to B ? I have created a little script doing this but it's a shame I can not do this easily in PG Admin. (because my script is still a bit of a manual process as I don't know the PG database well enough to have a completely automaticscript). May be, we changing the schema owner, PG Admin could prompt whether the schema objects owner should be changed as well (foreach objects). Cheers, L@u The Computing Froggy ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com
Laurent ROCHE a ecrit le 09/03/2007 12:58: > Is there an easy way (in one go) to change the owner of all database objects with PG Admin ? > > I am creating a schema with a script that assign the objects owner to login (I mean conection role) A . > Then I switch the schema owner to login (/conection role) B. > > But the objects are still owned by A. > Is there an easy way in PG Admin to change the owner obejcts from A to B ? > If you use PostgreSQL 8.2, you can REASSIGN OWNED BY A TO B; Use of REASSIGN/DROP OWNED is on the roadmap (http://www.pgadmin.org/development/roadmap.php) but they aren't done yet. > I have created a little script doing this but it's a shame I can not do this easily in PG Admin. > (because my script is still a bit of a manual process as I don't know the PG database well enough to have a completelyautomatic script). > > May be, we changing the schema owner, PG Admin could prompt whether the schema objects owner should be changed as well(for each objects). > We aren't sure that all objects in this schema are owned by the same user. But perhaps we can add some code to "emulate" REASSIGN OWNED for older PostgreSQL releases. Regards. -- Guillaume.