Then users with another user that the SYSDBA is not can't be created?

If possible do I eat?

Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: hvlad
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 13, 2010 5:14 PM
Subject: [firebird-support] Re: Error to create user



--- 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





[Non-text portions of this message have been removed]