New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL [CORE5898] #6156
Comments
Modified by: Emil Totev (emilt)description: The current role is not passed to the external data source when using 'execute statement ... on external' without AS USER, PASSWORD and ROLE additions. => The current role is not passed to the external data source when using 'execute statement ... on external' without AS USER, PASSWORD and ROLE additions. |
Commented by: @hvlad Could you show reproducible example ? I just check following (with current build of 3.0.4): firebird>isql inet://s:\Temp\eds\MASTER.FDB -user VLAD -pass vlad -role ROLE1 CURRENT_CONNECTION USER ROLE SQL> exit; firebird>isql inet://s:\Temp\eds\RDB0.FDB -user VLAD -pass vlad -role ROLE1 CURRENT_CONNECTION USER ROLE SQL> DB USR RL SQL> set term ;^ |
Commented by: @hvlad My bad, the sample it not correct. Below is correct one and it reproduces the issue: set term ^; execute block db = 's:\Temp\eds\MASTER.FDB'; -- remote set term ;^ |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: Emil Totev (emilt) Build 3.0.4.33036 is working OK for me, both for the test case and in my actual usage scenario. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 1 [ 10750 ] Fix Version: 3.0.4 [ 10863 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] Test Details: See also test for CORE4054. |
Submitted by: Emil Totev (emilt)
The current role is not passed to the external data source when using 'execute statement ... on external' without AS USER, PASSWORD and ROLE additions.
This has been acknowledged as a bug and fixed for 2.5.3 (see CORE4054 ), but the fix is not ported forward to version 3.
Commits: 79d16e6 b0ab147
====== Test Details ======
See also test for CORE4054.
The text was updated successfully, but these errors were encountered: