Riho,

> Is it possible to change the owner of database?
>
> In my application SYSDBA creates database file. Afterwards the program
> prompts user to backup its database. Currently user must also supply
> SYSDBA password for backup.
> I had a thought to give one user the full rights, so he/she could do the
> backup without SYSDBA being around.

You'd best using a different database and database object
owner than SYSDBA! Use a different user when creating the
database and use that user whenever you are adding objects
(tables, views, ...) to the database.

You can backup the database with SYSDBA and restore it
under a different user. The database owner will change,
but *not* the ownership of database objects. If you
completely want to change the owner of the database
and all database objects, then either create the database
with the new owner from scratch and pump all data from
the old into the new database, or you might get in
touch with me, because I've a tool that can do that
for you, without pumping any data or data loss.



HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com