> We have found that the following steps are necessary.
>
> 1. ensure owner exists as user
> 2. change owner in the system tables for procedures.
> 3. backup
> 4. delete the gdb file
> 5. restore
>
> If that doesnt work then the remaining problem is grants on the tables
> and views. We have a script that sorts those out.
>
>
> hrethantos wrote:
>
> >Hi All
> >
> >Is it possible to change the owner of a database without recreating
> >it and pumping all the data to the new db?
> >
> >Thanks
> >

OTOH - it takes only a couple of minutes to extract the metadata, change the
owner name, run the script and pump the data (perhaps longer if a lot of
data)
But the extraction and creation is almost automatic with IBExpert, and the
data pumping in also almost automatic with Clever Components data pump
add-in.
I've done it enough to not hesitate when I need to do it.

Alan