You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I created a new database.
I created new user with CREATE USER UNAME PASSWORD 'PASS' GRANT ADMIN ROLE;
I logged in with newly created account, specifying RDB$ADMIN role.
I tried to create a new user with CREATE USER UNAME1 PASSWORD 'PASS1' GRANT ADMIN ROLE;
The error is:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
add record error.
no permission for insert/write access to TABLE USERS.
Apparently, my newly created user UNAME should have SYSDBA privileges, but actually does not have them.
Submitted by: obucina (obucina)
I created a new database.
I created new user with CREATE USER UNAME PASSWORD 'PASS' GRANT ADMIN ROLE;
I logged in with newly created account, specifying RDB$ADMIN role.
I tried to create a new user with CREATE USER UNAME1 PASSWORD 'PASS1' GRANT ADMIN ROLE;
The error is:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
add record error.
no permission for insert/write access to TABLE USERS.
Apparently, my newly created user UNAME should have SYSDBA privileges, but actually does not have them.
Commits: ec4e491
====== Test Details ======
Test implemented only for 2.5 (no need for 3.0).
The text was updated successfully, but these errors were encountered: