Issue Details (XML | Word | Printable)

Key: CORE-3398
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: obucina
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

GRANT ADMIN ROLE not accepted

Created: 19/Mar/11 03:21 AM   Updated: 23/Apr/13 11:49 AM
Component/s: None
Affects Version/s: 2.5.0
Fix Version/s: 2.5.1

Environment: Intel E6850, 2GB, Win7 Pro 32


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 19/Mar/11 07:26 AM
Do you have the out-of-the-box installed security2.fdb or the one migrated from some prior FB version?

obucina added a comment - 19/Mar/11 08:33 AM
Out of the box installed.

Alexander Peshkov added a comment - 21/Mar/11 03:10 PM
Does not require frontporting - FB3 is using another way to access security database