Answers

Question and Answer:

  Home  Firebird

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

Use the following query:

SELECT DISTINCT RDB$OWNER_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 e-mail him directly to get it.

 203 views

More Questions for you: