Allow to specify plugin authorization statement EXECUTE STATEMENT -----------------------------------------------------------------
Key: CORE-4471 URL: http://tracker.firebirdsql.org/browse/CORE-4471 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Simonov Denis I have a problem with a bunch of 3 and Firebird Firebird 2.5 by operator EXECUTE STATEMENT. "335544472: Your user name and password are not defined. Ask your database administrator to set up a Firebird login." This occurs because the operator EXECUTE STATEMENT ON EXTERNAL DATA SOURCE connected via SRP. Of course, you can change the authentication method, but it will change immediately for the entire database. As I understand MAPPING can solve the inverse problem (connect to Firebird 2.5 Firebird 3.0), but not the one that I described. Maybe expand the operator EXECUTE STATEMENT so that it is possible to specify authorization plugin? EXECUTE STATEMENT {<sql_statement_string> |: <SQL_STMT_VARIABLE>} [(<input_parameters>)] [ON EXTERNAL [DATA SOURCE] <connection_string>] [WITH {AUTONOMOUS | COMMON} TRANSACTION] [USE PLUGIN <plugin_name>] [AS USER <user_name> [PASSWORD <password>]] [WITH CALLER PRIVILEGES] -- 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