with caller privileges option don't work with autonomous transaction option [CORE3799]

[firebird-automations]

Submitted by: eXandr (i.reg)

Is related to QA495

In execute statement the "with caller privileges" option doesn't work with "with autonomous transaction" option

Commits: a935f95 660fa3b

[firebird-automations]

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

[firebird-automations]

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.2 [ 10450 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

[firebird-automations]

Modified by: @hvlad

Version: 2.5.0 [ 10221 ]

Version: 3.0 Initial [ 10301 ]

summary: with caller privileges option dont work with autonomous transaction option => with caller privileges option don't work with autonomous transaction option

[firebird-automations]

Commented by: @hvlad

Simple test case

gsec -add vlad -pw v

isql -user SYSDBA -pass masterkey

create table t (id int);
set term ^ ;

create procedure p
as
begin
execute statement 'insert into t values(current_transaction)'
with caller privileges
with autonomous transaction;
end
^

grant all on table t to procedure p^
grant execute on procedure p to user vlad^
exit^

isql -user vlad -pass v

execute procedure p;

Statement failed, SQLSTATE = 28000
no permission for insert/write access to TABLE T
-At procedure 'P' line: 2, col: 3

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA495 [ QA495 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

[firebird-automations]

Commented by: @pcisar

Test created.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]