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.
