Subject Re: CREATE USER for a user who has the role RDB$ADMIN
Author W O
Nobody has an idea?

Greetings.

Walter.



On Mon, Jun 23, 2014 at 10:45 AM, W O <sistemas2000profesional@...> wrote:
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.

Why?

What can change the behaviour? Some previous command?

Windows 7 Ultimate, Firebird 2.5.2, SuperServer

Greetings.

Walter.