Re: Changing owner objects

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 completely automatic 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.