Subject Re: [firebird-support] Re: storeproc not executing after restoring database
Author Martijn Tonies
> > >but running a simple query on RDB$RELATIONS is a
> > > recipe for tears.
> >
> > This is exactly what the tool does.
> If it were 'exactly what the tool does' than anyone who used the said
> tool would end up with the problems reported by the OP. Clearly the
> tool does a bit more than update one field in a single system table

Right, there's more. RDB$PROCEDURES, for example, holds a column
OWNER_NAME as well.

> (although you correctly state that it achieves the ownership change by
> doing exactly what I advised the OP not to do).
> Here is another way to change ownership, much safer if you don't
> understand all the nuances of the Firebird system tables.
> 1. Create a second database with the correct owner.
> 2. Use a data pumping tool (such as IBDataPump) to copy the data to
> the database with the ownership you are happy with.
> Either that or pester Martijn for a copy of the Upscene tool ;)

Please pester Thomas : t.steinmaurer @ instead - he wrote it.

It most definately is the easiest and fastest way of doing such a thing.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!