Subject Re: [firebird-support] Re: storeproc not executing after restoring database
Author Martijn Tonies
> > > > I'm using Firebird 1.5. I am having 2 users, Sysdba and Mauleen.
> > > > Mauleen is having all rights on the database tables and
> storedProc. I
> > > > had updated the rdb$elations table and set the owner as mauleen for
> > > > each item.
> > >
> > > Whoa, why are you directly manipulating with the system tables?
> > >
> > > Use grants to set permissions, nothing else.
> >
> > Adam, do you know of any GRANT statement to change table ownership?
> No, I but know of backup-restore cycle to achieve that.

No, it doesn't. Backup/restore changes ownership of the database,
not of the objects inside it.

> I think there is also a tool somewhere that does the necessary behind
> the scenes stuff,

Yes, there is - created by Thomas Steinmaurer of Upscene Productions.

>but running a simple query on RDB$RELATIONS is a
> recipe for tears.

This is exactly what the tool does.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!