Subject Unsuccessful Metadata Update
Author Daniel Rail
Hi everybody,

I'm getting the following error message in my Delphi 5 application (just
FYI I'm using IBO 3.6 for connectivity):

ISC ERROR CODE:335544351

ISC ERROR MESSAGE:
unsuccessful metadata update
no S privilege with grant option on table/view
SCHEDULER_TB_APPTYPES

Here's the statement being executed:
GRANT ALL ON SCHEDULER_TB_APPTYPES TO USER SYSDBA WITH GRANT OPTION

What bothers me, is that the user that I'm using to log on Interbase is the
owner of the table, but not SYSDBA. As soon as I use SYSDBA, there's no
problem.

The application that I'm running is to update a client's database. There
are a few steps that are executed prior to this. They are a full backup,
then a full restore(with rewriting of db), update the domains, update the
generators, then update the tables and this is where I get the error.

Any suggestions on how to work around this type of problem?


Daniel Rail