Issue Details (XML | Word | Printable)

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

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: 27/Mar/14 01:20 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

Issue Links:
Relate
 

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: 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
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