Database shutdown

[Tomasz Dubiel]

Hello.

I have one problem. On one Firebird 2.5.7 server I have created user with only select rights to given databases and I have no idea what I do incorrectly. With any other user I connect to the database with no problem, but when connecting with freshly created user with only select rights, I have error:

Database shutdown [SQLState:HY000, ISC error code:335544528].

Can you explain me why Firebird is not letting new user access the database? I even backup and restored security2.fdb, but with no change.

[Tomasz Tyrakowski]

Maybe your target database is indeed in the shutdown mode (you performed
gfix -shut on it earlier). Try gfix -online -user SYSDBA -password <pwd>
target_database.
In shutdown mode, only the SYSDBA and the owner of the database can
connect, that's probably why your new user cannot.
Look here:
https://firebirdsql.org/file/documentation/html/en/firebirddocs/gfix/firebird-gfix.html#gfix-dbstartstop
for more info.

regards
Tomasz

________________________________


Ta wiadomość zawiera poufne informacje przeznaczone tylko dla adresata. Jeżeli nie jesteście Państwo jej adresatem, bądź otrzymaliście ją przez pomyłkę, prosimy o powiadomienie o tym nadawcy oraz trwałe jej usunięcie.

[Tomasz Dubiel]

OK, thank you. I forgot that sysdba AND OWNER of the database can still connect even if the database is shutdown. SYSDBA was ok for me, but connecting with owner was the misleading point.Thank you.