|Subject||Re: [firebird-support] Re: storeproc not executing after restoring database|
> > > > I'm using Firebird 1.5. I am having 2 users, Sysdba and Mauleen.No, it doesn't. Backup/restore changes ownership of the database,
> > > > 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.
not of the objects inside it.
> I think there is also a tool somewhere that does the necessary behindYes, there is - created by Thomas Steinmaurer of Upscene Productions.
> the scenes stuff,
>but running a simple query on RDB$RELATIONS is aThis is exactly what the tool does.
> recipe for tears.
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!