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