Subject RE: [firebird-support] changing owner
Author Alan McDonald
> 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
But the extraction and creation is almost automatic with IBExpert, and the
data pumping in also almost automatic with Clever Components data pump
I've done it enough to not hesitate when I need to do it.