OB1 wrote:

> 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?

If you're not concerned with user security anyway, you could just grant
rights to PUBLIC whenever you add any tables, sp's, etc.. If you plan
on tightening security in the future for access to certain things, then
you have to grant rights to each role/user individually.

Woody (TMW)