|Subject||Re: [firebird-support] Re: storeproc not executing after restoring database|
> > >but running a simple query on RDB$RELATIONS is aRight, there's more. RDB$PROCEDURES, for example, holds a column
> > > 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
OWNER_NAME as well.
> (although you correctly state that it achieves the ownership change byPlease pester Thomas : t.steinmaurer @ upscene.com instead - he wrote it.
> 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 ;)
It most definately is the easiest and fastest way of doing such a thing.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!