Subject Re: [firebird-support] Upgrading to 1.5, will I loose my users?
Author Thomas Steinmaurer
Hi Benton,

> Currently I work with FB 1.0 on Linux. Want to upgrade to 1.5, but
> wonder what is going to happen to the users and their grants.

Grants are stored in your database, so that's not an issue.

For migrating a security database from 1.0 to 1.5, simply make a backup
of isc4.gdb with Firebird 1.0 and restore it under Firebird 1.5 to
security_tmp.fdb using SYSDBA for the restore process.

Then, shut down the Firebird 1.5 server, rename the existing
security.fdb to something else. Now, rename the previously restored
database security_tmp.fdb to security.fdb and restart the Firebird 1.5
Server.


--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com