Grant field rights + grant select to package = internal Firebird consistency 
check (bad ACL (293), file: grant.cpp line: 2431) 
-------------------------------------------------------------------------------------------------------------------------------

                 Key: CORE-5280
                 URL: http://tracker.firebirdsql.org/browse/CORE-5280
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 3.0.0
            Reporter: Олег Короткий
            Priority: Critical


create user test1 password '1';
create database 'd:\test.fdb' page_size 8192 user SYSDBA password 'masterkey';
connect d:\test.fdb user SYSDBA password masterkey;
create table test (id bigint not null primary key);

SET TERM ^ ;

CREATE PACKAGE NEW_PACKAGE
AS
begin

end^

CREATE PACKAGE BODY NEW_PACKAGE
AS
begin

end^

SET TERM ; ^

GRANT EXECUTE ON PACKAGE NEW_PACKAGE TO SYSDBA; 
GRANT SELECT ON test TO PACKAGE new_package;

GRANT UPDATE (id) ON test TO TEST1;
-----------------------------------------------------------
C:\Program Files\Firebird\Firebird_3_0>isql -input "d:\1.txt"
Use CONNECT or CREATE DATABASE to specify a database
Rolling back work.
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (bad ACL (293), file: grant.cpp line: 2431)
After line 25 in file d:\1.txt
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)
After line 27 in file d:\1.txt
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)
After line 27 in file d:\1.txt

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to