[#CORE-3799] with caller privileges option don't work with autonomous transaction option

Firebird Core

with caller privileges option don't work with autonomous transaction option

Created: 26/Mar/12 01:44 PM Updated: 29/Mar/12 12:09 PM

Component/s:

Engine

Affects Version/s:

3.0 Initial, 2.5.0, 2.5.1

Fix Version/s:

2.5.2, 3.0 Alpha 1

Time Tracking:

Not Specified

Planning Status:

Unspecified

Description

« Hide

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

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 29/Mar/12 12:09 PM

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