Commented by: @dyemanov

Sounds like an IBExpert bug. What if you execute this statement in ISQL?

Commented by: Vsevolod Migdisov (vmigdisov_gmail.com)

ISQL: the same result. And there is another user who has the same problem:
CORE696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#⁠action_16850

Commented by: @dyemanov

Confirmed and fixed.

Commented by: Pabloj (pabloj_sourceforge)

Sorry but this bug should be reopened, I'm testing a firebird snapshot and I get a different error from create user, this time is a can't add record, see the transcript:

C:\Program Files\Firebird\Firebird_2_5\bin>isql -u sysdba -p masterkey localhost
:pippo2 -r sysdba
Database: localhost:pippo2, User: sysdba, Role: SYSDBA
SQL> create user pippo password 'pippo';
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-add record error

SQL> select rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database;

RDB$GET_CONTEXT

2.5.0
SQL> exit;

C:\Program Files\Firebird\Firebird_2_5\bin>isql -z
ISQL Version: WI-T2.5.0.20737 Firebird 2.5 Alpha 1
Use CONNECT or CREATE DATABASE to specify a database
SQL>

Commented by: Pabloj (pabloj_sourceforge)

I'm sorry, fact is the user already exists, it's just a matter of returning a more descriptive message.

Commented by: Vsevolod Migdisov (vmigdisov_gmail.com)

Firebird 2.5.0.20709
"EXECUTE BLOCK" statement does not support "CREATE USER":

execute block
as
begin
EXECUTE statement 'create user test1 password ''test1''';
EXECUTE statement 'create user test2 password ''test2''';
end

returns:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Execute statement error at jrd8_execute :\n335544351 : unsuccessful metadata update
336723987 : add record error
Statement : create user test2 password 'test2'\nData source : Internal::.

Commented by: @AlexPeshkoff

Issue confirmed, please open new item for it.
I will take care next week.