Issue Details (XML | Word | Printable)

Key: CORE-4468
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Robert
Votes: 0
Watchers: 3
Operations

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

FB3: CREATE USER GRANT ADMIN ROLE does not work

Created: 20/Jun/14 05:15 PM   Updated: 27/Jun/14 12:01 PM
Component/s: Security
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

Time Tracking:
Not Specified

Environment: Windows

Planning Status: Unspecified


 Description  « Hide
Using WI-T3.0.0.30809 Firebird 3.0 Alpha 2, CREATE USER GRANT ADMIN ROLE does not work (i.e. rdb$admin role is not assigned to user in the security database)

Test scenario:

1) Connect to regular database Test.fdb by user SYSDBA

2) CREATE USER Test PASSWORD 'masterkey' GRANT ADMIN ROLE
   COMMIT

3) GRANT rdb$admin TO USER Test
   COMMIT

4) Connect to regular database Test.fdb by user Test with role rdb$admin

5) CREATE USER Test2 PASSWORD 'masterkey'
   COMMIT

=> SQL Message : -901 Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

Also using fbsvcmg after step 2:

C:\Program Files\Firebird\Firebird_3_0>fbsvcmgr localhost:service_mgr user sysdba password masterkey action_display_user_adm
Login Full name uid gid adm
SYSDBA Sql Server Administrator 0 0 no
TEST 0 0 no <<< *** expected: yes

I've executed the same scenario with FB2.5, and here it works correctly.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Robert added a comment - 20/Jun/14 05:18 PM
complete error message:
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 access to TABLE PLG$SRP_VIEW