firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Permissions of implicit domains are left after the table is dropped

Open asfernandes opened this issue 11 months ago • 0 comments

create table t1 (n1 integer);
commit;

select * from rdb$fields where rdb$field_name = 'RDB$1';
-- 1 record

select * from rdb$user_privileges where rdb$relation_name = 'RDB$1';
-- 1 record

drop table t1;
commit;

select * from rdb$fields where rdb$field_name = 'RDB$1';
-- 0 record

select * from rdb$user_privileges where rdb$relation_name = 'RDB$1';
-- 1 record

asfernandes avatar Jan 24 '25 01:01 asfernandes