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

Time Tracking:
Not Specified

Environment: Intel E6850, 2GB, Win7 Pro 32

Planning Status: Unspecified


 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   Work Log   Change History   Version Control   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