Subject | Re: [firebird-support] SYSDBA, security and backups |
---|---|
Author | Thomas Steinmaurer |
Post date | 2009-03-23T06:56:43Z |
> 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.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/