Subject Creating a Role like SYSDBA
Author OB1

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

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?



[Non-text portions of this message have been removed]