Yes, I make all of it and It give the error.

I use flamerobin 0.9.3.1924
Firebird 2.5.0.26074 SS

Database file ODS Version 11.2
Page size 4096
Pages 1703
Size on disk 6.65MB
Page buffers 2048
Read only false

Settings Dialect 3
Default character set ISO8859_1
Sweep interval 20000
Forced writes yes

1. As SYSDBA, create a user e.g. create user ismael
CREATE USER ismael PASSWORD 'test';

2. As SYSDBA, grant the RDB$ADMIN role to user ismael
GRANT RDB$ADMIN TO ismael;

3. Log as ismael
CREATE USER pepe PASSWORD 'test'

Context: Transaction::Commit
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

Engine Code : 336723987
Engine Message :
add record error
no permission for insert/write access to TABLE USERS

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

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 13, 2010 2:32 PM
Subject: Re: [firebird-support] Error to create user



At 06:12 AM 14/10/2010, you wrote:
>1. I believe a new user
>2. With that user I believe a database
>3. Deposit it to the role rdb$admin

Assuming you are using Fb 2.5:

1. As SYSDBA, create a user, e.g. ismael
2. As SYSDBA, grant the RDB$ADMIN role to user ismael
3. Log in as ismael, supplying the role 'RDB$ADMIN'

Now, user ismael should succeed in creating another user.

>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'
>Prepare time: 0.032s
>Plan not available.
>
>Executing...
>Done.
>0 fetches, 0 marks, 0 reads, 0 writes.
>0 inserts, 0 updates, 0 deletes, 0 index, 0 seq.
>Delta memory: 4108 bytes.
>Total execution time: 0.074s
>Script execution finished.
>Commiting transaction...
>*** IBPP::SQLException ***
>Context: Transaction::Commit
>
>SQL Message : -901
>Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
>
>Engine Code : 336723987
>Engine Message :
>add record error
>no permission for insert/write access to TABLE USERS
>
>As you could create user without being connected like sysdba?

See 1, 2, 3 above. But it won't work if your server is not v.2.5 and your database is not ODS 11.2

./heLen





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