role not passed on external execute stmt
----------------------------------------
Key: CORE-4054
URL: http://tracker.firebirdsql.org/browse/CORE-4054
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2
Environment: Win7, XP, Superserver, Superclassic
Reporter: Volker Rehn
Looks like the current role is not being passed through to an external database
when running a remote execute statement without giving credentials and host.
Documentation says in section authentication that "If all three [user, password
and role, vr] are absent and the connect string contains no hostname, then the
new connection is established on the local host with the same user and role as
the current connection."
The user makes it through, but the role at the remote db is NONE. (The role is
granted to the test user within both databases). Test case:
execute block
returns (cuser varchar(30),
crole varchar(30)) as
begin
for execute statement 'select current_user, current_role from rdb$database'
on external 'ext_db'
into :cuser, :crole
do suspend;
end;
Regards, Volker
--
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
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
