> At 03:53 AM 11/08/2004 +0000, you wrote:
> >What privileges does a user need to perform a backup?
>
> No especial privileges...but the user must be either SYSDBA or the database
> owner (which you can discover by querying RDB$DATABASE).

RDB$DATABASE isn't helpful here, IMHO. ;-)

The following should do the trick:

SELECT
RDB$GRANTOR
FROM
RDB$USER_PRIVILEGES
WHERE
RDB$RELATION_NAME = 'RDB$ROLES'
AND RDB$USER = 'PUBLIC'



Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com