Re: [Firebird-devel] execute statement on external role

2015-02-07 Thread James Starkey
> > Store your user, password and role in context variable and > > use it in execute statement > > > Regards, > > Karol Bieniaszewski > > > - Reply message - > > Od: "Geoff Worboys" > > > Do: > > > Temat: [Firebird-devel] execut

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Alex Peshkoff
On 05.02.2015 17:47, Geoff Worboys wrote: > Alex Peshkoff wrote: > [...] >>> Currently in FB v2.5.3, if I do NOT specify any of USER, >>> PASSWORD or ROLE then Firebird will happily attach to local >>> databases using the current user's credentials: user name >>> and role - I'm guessing password i

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Geoff Worboys
Alex Peshkoff wrote: [...] >> Currently in FB v2.5.3, if I do NOT specify any of USER, >> PASSWORD or ROLE then Firebird will happily attach to local >> databases using the current user's credentials: user name >> and role - I'm guessing password is assumed rather than ever >> specified through the

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Alex Peshkoff
On 05.02.2015 16:27, Geoff Worboys wrote: > Alex Peshkoff wrote: >> On 05.02.2015 15:36, Geoff Worboys wrote: >>> 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. >>> >>> Specifi

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Geoff Worboys
Alex Peshkoff wrote: > On 05.02.2015 15:36, Geoff Worboys wrote: >> 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 he

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Geoff Worboys
Vlad Khorsun wrote: > 05.02.2015 14:36, Geoff Worboys wrote: >> 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?

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Vlad Khorsun
05.02.2015 14:36, Geoff Worboys wrote: > 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? Why do you think so ? See

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Alex Peshkoff
On 05.02.2015 15:36, Geoff Worboys wrote: > 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 shoul

[Firebird-devel] execute statement on external role

2015-02-05 Thread Geoff Worboys
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