Subject Re: Error to create user
Author hvlad
--- In, "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.