Regression in 6.x: ALTER DATABASE fails with "no permission for ALTER access to DATABASE"

[Pavel Zotov]

Following script unexpectedly fails with " no permission" since 1b827d9f

==========

set bail on;
set list on;
set echo on;
shell if exist R:\Temp\tmp4test.11371.tmp del R:\Temp\tmp4test.11371.tmp;
create database 'localhost:R:\Temp\tmp4test.11371.tmp' user SYSDBA password 'masterkey';
alter database set linger to 0;
commit;
select rdb$linger from rdb$database;
quit;

==========

Outcome:

==========

Statement failed, SQLSTATE = 28000
unsuccessful metadata update
-ALTER DATABASE failed
-no permission for ALTER access to DATABASE

==========

Seems that only Windows is affected.

This is link to "adjacent" 6.x snapshots: 

20260720_234557-6.0.0.2084-466d61d -- works fine

20260721_080314-6.0.0.2084-1b827d9 -- contains regression

[Dmitry Yemanov]

22.07.2026 13:21, Pavel Zotov пишет:

> Following script unexpectedly fails with " no permission" since 1b827d9f

> <https://github.com/FirebirdSQL/firebird/
> commit/1b827d9fbc3231284c6126f8dee7308419cca86a>

It should be already fixed in master.


Dmitry

[Pavel Zotov]

PS.

Linux also is affected.

(last QA run could complete on Linux because appropriate .sh scenario has no 'alter DB set linger to ...' statement). 

[Mark Rotteveel]

On 22-07-2026 12:32, Pavel Zotov wrote:
> 22.07.2026 13:21, Pavel Zotov пишет:
>
>  Following script unexpectedly fails with " no permission"
> since 1b827d9f

>  <https://github.com/FirebirdSQL/firebird/ <https://github.com/
> FirebirdSQL/firebird/>

>  commit/1b827d9fbc3231284c6126f8dee7308419cca86a>
>
>
> It should be already fixed in master.
>

> да, увидел только что.
> 0xFF.
> текстовый редактор внутри fb-devel'a - сущее g@vno :-/
> да и сама страница какая-то деревянная: я не вижу свежих сообщений пока
> ввожу свой текст.

Please post in English to the list.

Mark
--
Mark Rotteveel

[Pavel Zotov]

Please post in English to the list.
Mark

Yes, I accidentally mixed up the windows with the editor. Sorry :-[