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
>
>
>
>