REASSIGN OWNED BY in current database only

[Andrus <kobruleht2@xxxxxx>]

Hi!

Cluster contains lot databases.

All objects in database should owned by separate role  whose name is in form

databasename_owner

where databasename is this database name in cluster.

This role in granted to cluster users who should have acces to this database.

Database is restored  from other cluster where is has different name.

    After that

REASSIGN OWNED BY originaldbname_owner TO restoreddbname_owner

is used to force this role in restored database.

This command changes also owner of global objects also.

How to change  owner only in current database, leaving global objects owner unchanged ?

    Andrus.