Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
firebird-automations opened this issue Jun 14, 2016 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Олег Короткий (олег короткий)

Votes: 1

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Олег Короткий (олег короткий)

without
GRANT UPDATE (id) ON test TO TEST1;
I don't get an error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant