Subject | AW: [firebird-support] Re: cannot connect to a restored database |
---|---|
Author | Thomas von Stetten |
Post date | 2004-01-06T18:43:32Z |
Nando,
found two articles about that a few weeks ago and the solution worked fine -
for me (using IB6.0.2).
Type <interbase owner change> at google.com and read the first _two_ links
from the same domain. (I don't know if it's allowed to post foreign links
here - so I decided to tell you how to search).
BTW when restoring a database the current (db-)user becomes the owner of all
systemtables (RDB$*). For all the other tables, views,... the owner is
restored from the gbk-file.
regards
Thomas
>...Can I fix the ownerships by updating RDB$RELATIONS?Yes, you can. But you have to update more than the RDB$RELATIONS table! I
found two articles about that a few weeks ago and the solution worked fine -
for me (using IB6.0.2).
Type <interbase owner change> at google.com and read the first _two_ links
from the same domain. (I don't know if it's allowed to post foreign links
here - so I decided to tell you how to search).
BTW when restoring a database the current (db-)user becomes the owner of all
systemtables (RDB$*). For all the other tables, views,... the owner is
restored from the gbk-file.
regards
Thomas