Subject Re: [firebird-support] storeproc not executing after restoring database
Author Lucas Franzen
mauleen2006 schrieb:
> Hello,
> 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.
> Then i've taken backup of the database as i'm owner of the database
> and then restored it back.
> Now when i've tried to execute a storedproc. an error occurs as follows:

If it's a stroed procedure without dependencies then login as owner of
the procedure, drop it, relogin as mauleen and then recreate it.