Subject Re: [firebird-support] Creating a Role like SYSDBA
Author Thomas Steinmaurer

> Currently, my application accesses a Firebird v1.54 database using SYSDBA.
> Whilst not ideal, it has worked a treat especially when I release database
> tweaks. I now want to create a User especially for my application and
> assign them a Role. My questions:
> 1. Is it possible to create a role and give them access to everything in my
> DB? Or do I need to grants them access to each table, view etc
> individually?
> 2. What happens when I release a database tweak, possibly adding another
> table, I assume I have to update the permissions of the Role to give them
> access to that table. With SYSDBA, it just works. Is there anything
> similar for a User using a Role?

When starting with Firebird, it's very convenient to use SYSDBA as
default user/owner of a database, tables, ... but you might get into
trouble with that, if you need to deploy your application / database to
an already existing Firebird installation.

From the feedback we get on our tool called FBOwnerMigrator, which
allows you to change the owner of the databse, tables, ... without
re-creating the database from scratch (including pumping data over),
people are VERY, VERY happy with getting away from SYSDBA as database owner.

If you are in need for migrating the owner to a SYSDBA different user,
then send me an email and I will give you the download link for FBOM.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions