Hi,
This is simple
Store your user, password and role in context variable and use it in execute
statement
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: "Geoff Worboys" <ge...@telesiscomputing.com.au>
Do: <firebird-devel@lists.sourceforge.net>
Temat: [Firebird-devel] execute statement on external role
Data: czw., lut 5, 2015 13:36
Hi,
Firebird v2.5.3
I've been studying the source trying to understand the reasons
behind a particular aspect of EXECUTE STATEMENT with ON EXTERNAL.
Specifically, why are USER PASSWORD and ROLE tied together here?
I had thought it should have been feasible to have
EXECUTE STATEMENT issued with a specific ROLE but no USER and
PASSWORD, and still be able to use the current user credentials
and it would be up to the external database to accept or reject
the requested role access.
In the code this appears to be a deliberate restriction rather
than a practical matter of what is possible, so I am imagining
there must have been security or other concerns about this.
Can someone enlighten me, or maybe hint where I might find prior
discussions on this (I can't find anything in my archives of
this list).
--
Geoff Worboys
Telesis Computing Pty Ltd
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
