|Subject||Re: [firebird-support] SYSDBA, security and backups|
> if i am to set up scheduled backups at client end then i am forced to expose the SYSDBA username and password in the batch file am i not?By NOT using SYSDBA as the owner of databases and database objects
> how can i facilitate backups without giving away our crown jewels?
(tables, views, ...).
This happens when you create the database or its objects when connected
as SYSDBA. Either recreate your database with a new owner/user or use
our tool called FBOwnerMigrator (download link on request), which allows
you to migrate the owner on-the-fly.
Although, you still need to supply the password of the new owner in the
batch file then, but it won't be the password of SYSDBA anymore. FWIW.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and