Subject RE: [firebird-support] Change database owner / privileges for all tables of a database
Author Alan McDonald
> Hello,
> how can I change the owner of a database, or grant privileges for _all_
> tables of a database with one statement? GRANT doesn't seem to take
> wildcards and in that section of the data definition guide there is no
> mention at all of granting privileges to more than one table at once. Not
> even select privilege, which might be appropriate in many cases.
> Did I miss the right place to look for the information or isn't
> it possible?
> Thank you,
> Koczian

changing ownership is something different to the rest of your questions.
If you want to change ownership, Thomas Steinmaurer has a very neat little
utility which does that - you need to ask him personaly for it. He's on this

As for grants, I think your best bet is to create a role, then grant all
tables to teh role, then when you need to add a user, you simply grant the
role to the user.

If you only ever want to ave one user to use your database, then changing
owner is your best bet.