Subject RE: [firebird-support] Merging security databases
Author Alan McDonald
>
> I need to be able to merge 2 security databases. Is there an easy way
> to do this? I tried writing a program to do it but Firebird 2 servers
> give me an error:
>
> no permission for direct access to security database.
>

either take both offline, rename them and treat them as normal databases. Do
what you want, then replace them again.
or use something like this
http://www.meta.com.au/index.php?option=com_docman&task=cat_view&gid=35&Item
id=26

but be aware that syncing them even using SYSDBA and the services API, you
will be unable to sync the passwords. You'll need to reset them all.


Alan