You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: