When you connect to the database, which was originally, everything is fine. But if I try to connect to the database I created through the terminal, I get an error that the user does not have privileges.

*** IBPP::SQLException *** Context: Database::Connect Message: isc_attach_database failed SQL Message : -551 This user does not have privilege to perform this operation on this object. Engine Code : 335544352 Engine Message : no permission for read-write access to database /var/lib/firebird/2.5/data/first_database.fdb

And this is when connecting from any user. What from the admin, that from the usual. Connecting via FlameRobin GUI. Yes, and when connecting through the terminal, it also knocks out the same.

  • Well, ask what is this user who doesn’t have the privilege to perform this operation on this object . And on behalf of sysdba, ask who has what rights to this newly created database. Well, either when creating (or immediately after creation, directly from the same terminal), indicate to whom and what is possible in this database - the one who created the database has the necessary rights for this - and at the same time, whoami. - Akina
  • Question: how to do it? - Andrei

1 answer 1

Understood.

If you receive an error message, such as "Statement failed, SQLCODE = -551, this means that the server process can not read or access write to database file. Change the database owner for firebird users:

 **# cd /var/lib/firebird/2.5/data/** **# chown firebird:firebird employee.fdb**