Issue Details (XML | Word | Printable)

Key: CORE-3799
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: eXandr
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

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

Created: 26/Mar/12 01:44 PM   Updated: 25/Sep/15 12:30 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

Issue Links:

QA Status: Done successfully

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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
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
  execute statement 'insert into t values(current_transaction)'
    with caller privileges
    with autonomous transaction;

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

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

Pavel Cisar added a comment - 25/Sep/15 12:30 PM
Test created.