Subject Adding fields as normal user
Author Riho-Rene Ellermaa

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
-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