Hello

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?

Thanks

OB


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