> On Jan 18, 2007, at 8:53 AM, Uwe Grauer wrote: > >> You can find out the owner of firebird databases by running this >> query: >> >> SELECT DISTINCT RDB$OWNER_NAME AS DATABASE_OWNER >> FROM RDB$RELATIONS >> WHERE (RDB$SYSTEM_FLAG = 1); > > OK, I used an update based on that query to change the owner of the > demo database to 'WEBUSER'. I created an AppWiz app, and was able to > add/delete/update, so this should be working now. Can anyone else > verify that the demo database is working? > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com
Ed, did you update in the system table? That's not recommended unless you are really sure about it. Often it's not enough to change it in one table, because there could be side effects! So please never do updates in the system tables. It might be Better to create a new db as the owner. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
