Jonathan Neve wrote:

>>Create a
>>new user and get them all to connect under that instead.
>
> This sounds to me like a lot of fuss and bother for nothing. That means
> that I'll constantly have to be maintaining the grants for an
> all-powerful user, so as to make sure that it always says all-powerful.
> If I want it be all-powerful, why not use SYSDBA, which is already
> all-powerful?

Is actually really easy.
You can use a statement like this:

select 'grant all on '||RDB$RELATION_NAME||' to all_powerful_user;'
from RDB$RELATIONS
where (RDB$SYSTEM_FLAG = 0 or RDB$SYSTEM_FLAG is null)
ORDER BY 1

Just use the output to grant access to all views/tables.
Similar sql can be used for stored procedures.

--
Milan Babuskov
http://fbexport.sourceforge.net