Subject Re: [firebird-support] Error to create user
Author Helen Borrie
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