--- In firebird-support@yahoogroups.com, "Ismael L. Donis García" wrote:

>
> 1. I believe a new user
> 2. With that user I believe a database
> 3. Deposit it to the role rdb$admin

He became SYSDBA in that database, not at secury database.

> And when I try to create an user from that user you give me the following error:
>
> Starting transaction...
> Preparing query: CREATE USER alex PASSWORD 'test'

...

> add record error
> no permission for insert/write access to TABLE USERS

It is as expected. You should be SYSDBA in security2.fdb to manage users.

Regards,
Vlad