secdb | Timeseries market data database | Database library

Firebird has administrator roles on two levels:

1. In a normal user database. This allows you to do everything inside that database (create objects, grant or revoke rights to users, etc)
2. In the security database. This allows you to create or alter users and grant or revoke certain global privileges like 'create database', but also user administration (creating, altering or dropping users).

Having the admin role in a normal database is not sufficient to create, alter or drop a user (unless that normal database is also used as a security database). You will also need to have the admin role in the security database to be able to create or alter users.

To grant a user the admin role in the security database, a user with admin rights in the security database needs to execute the following statement (while connected using the RDB$ADMIN role):