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

Reply via email to