Subject | Re: [firebird-support] How to change the owner of database |
---|---|
Author | Milan Babuskov |
Post date | 2005-07-18T22:31:05Z |
Sorry wrote:
will be owned by other user. So you have these options (that I know of):
1. Dump metadata to sql script with (isql -x option), create new
database with new owner and run that sql on it (edit if needed). Then
pump existing data from old database (using some tool like FBCopy).
2. Use tool like FB Owner Migrator (I don't know where you can get it,
but you can ask at firebird-tools group if you like).
3. Modify system tables manually. These scripts might help:
http://www.bcp-software.nl/ib/changedatabaseowner.html
http://www.bcp-software.nl/ib/changerelationowner.html
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org
> How can i change the owner of the database?You could backup and restore with other user, but all database object
will be owned by other user. So you have these options (that I know of):
1. Dump metadata to sql script with (isql -x option), create new
database with new owner and run that sql on it (edit if needed). Then
pump existing data from old database (using some tool like FBCopy).
2. Use tool like FB Owner Migrator (I don't know where you can get it,
but you can ask at firebird-tools group if you like).
3. Modify system tables manually. These scripts might help:
http://www.bcp-software.nl/ib/changedatabaseowner.html
http://www.bcp-software.nl/ib/changerelationowner.html
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org