Hi!

I want to automatically update my application's database. The users download program patch, where I check the database version number and then run small script that adds/drops some fields in some tables.
I have been using this method successfully in my other apps where I silently connect to database as SYSDBA and usernames are not used.
In this application users log into FB database by their usernames and I run into problem - I get error "unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-no permission for control access to TABLE Mytable


Is there any possibility for me to succeed? I dont like the solution that users must run to search sysadm to get the upgrade installed.


Riho-Rene Ellermaa
senior programmer
Hansabank