|Subject||CREATE USER for a user who has the role RDB$ADMIN|
Something strange has occurred.
Yesterday I try to create a user after connecting with the role RDB$ADMIN
No success. An error message.
Some minutes ago I did exactly the same thing, because I wanted to copy the error message and write it in an e-mail, asking for help.
However, now it works.
I write in ISQL.EXE:
CONNECT BLOG_DB USER WOJEDAR PASSWORD '123456' ROLE RDB$ADMIN;
CREATE USER PRUEBA PASSWORD '123456';
The user WOJEDAR has the role RDB$ADMIN since months ago. Yesterday I wrote this query:
SELECT RDB$USER FROM RDB$USER_PRIVILEGES WHERE RDB$RELATION_NAME = 'RDB$ADMIN';
to verify and yes, the user WOJEDAR is there.
Same computer, same Firebird version, same user, same password, same role, same command line, however yesterday it doesn't work and today it works.
What can change the behaviour? Some previous command?
Windows 7 Ultimate, Firebird 2.5.2, SuperServer