At 14:10 01.10.2002 +0300, you wrote:

>Is it possible to create another user with full SYSDBA rights
>(create/modify/delete users, grant rigths)? If yes, then how?
>
>Currently my app users are stored into ISC4 and all users administration
>is done by SYSDBA.
>But some users have more than one application that uses firebird and they
>want to have separate admin for my programs user administration.

As Martijn said, you cannot give another user full SYSDBA rights. However,
rights to the tables are given to SYSDBA as well as the creator of each
table (and I guess the same goes for stored procedures, views etc). So if
you write a script creating your tables/SPs etc. and make sure that script
is run by the person supposed to do the administration, (s)he should be
able to grant the rights for existing users.

Alternatively, if the databases are already in production, you could write
a script to be executed by SYSDBA which grants necessary rights WITH GRANT
OPTION.

Probably not quite what your users desire, but the best you can do and
possibly enough for them to be happy with the compromise?

HTH,
Set