FIREBIRD Questions and Answers

How to determine who is and change the owner of database?

Use the following query:
SELECT DISTINCT RDBSO WNER NAME AS DATABASE OWNER
FROM RDB$RELATIONS
WHERE (RDB$SYSTEM FLAG = 1 )
Please note that in order to change the owner, it is not enough (or even advisable) to change this column only, as many other metadata fields are involved (there are multiple tables which have this field and SQL privileges need to be updated as well). There is a handy tool by Thomas Steinmaurer that can do this automatically, but you’ll have to email him directly to get it.