FB3: CREATE USER GRANT ADMIN ROLE does not work
-----------------------------------------------
Key: CORE-4468
URL: http://tracker.firebirdsql.org/browse/CORE-4468
Project: Firebird Core
Issue Type: Bug
Components: Security
Affects Versions: 3.0 Alpha 2
Environment: Windows
Reporter: Robert
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
