Hi,

> My problem is I got a Firebird database file from a machine 'A'.
> Then copy/paste this file to machine 'B', in this case who will be the
> database owner? Can I change the ownership?

The database owner will stay the same. And you should only copy
a database file when the server isn't running (no access to the database).


Yes, you can change ownership of the database by doing a backup
with SYSDBA/current owner and a "restore" with the new owner.

However, the objects inside your database will keep the old owner
(the user that created those objects).

At Upscene, we have developed a tool that automates changing
owership of your database (objects), if you'd like a copy, send
an e-mail to t.steinmaurer @ upscene.com


Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com