Subject | Error to create user |
---|---|
Author | Ismael L. Donis GarcĂa |
Post date | 2010-10-13T17:12:20Z |
1. I believe a new user
2. With that user I believe a database
3. Deposit it to the role rdb$admin
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?
Regards
=========
|| ISMAEL ||
=========
[Non-text portions of this message have been removed]
2. With that user I believe a database
3. Deposit it to the role rdb$admin
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?
Regards
=========
|| ISMAEL ||
=========
[Non-text portions of this message have been removed]