It certainly resides in security database too.
What do you intend with that hack?
Someone having direct access to database file can open it with a server on that he knows sysdba password - or with embedded stuff not using any passwords at all. No matter if the DB is "owned" by SYSDBA or some other username.
To protect database from direct access you can use database encryption.
For v3 onwards you find plugin description in manuals or you can buy closed source plugins for that.
For FB25 you have to enable the old encryption stuff normally
disabled.
Hello.
I wonder if a database ( firebird 2.5 fire ) is opened as a text file with some text editor ( like Notepad++), and SYSDBA is replaced as binary text with an string with the same length ( this part is working ) - will this generally change the SYSDBA or it is hidden somewhere else as well ?
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/f476bfb6-19fe-4f66-abc6-0cb92b467d2an%40googlegroups.com.
isn't it simpler to upgrade to Firebird 3 or 4 and use the RDB$ADMIN role?
Regards,
Karol Bieniaszewski
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/7c30ac2a-6527-3cee-d9f7-eaa4b85e7c6c%40ibphoenix.com.
But this application have user name at start at all? If not, without source code changing user name is hard, binary file editing, but maybe it is a s text in executable…
Regards,
Karol Bieniaszewski
Od: 'Dimitry Sibiryakov' via firebird-support
Wysłano: niedziela, 15 października 2023 13:16
Do: firebird...@googlegroups.com
Temat: Re: [firebird-support] Weird approach to replace SYSDBA
Karol Bieniaszewski wrote 15.10.2023 13:14:
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/aae9a2b8-fb71-42a1-771d-ae2283e3eb60%40ibphoenix.com.
The replacement is by request. This is not something I can manage. It is mandatory as given from the superiors.
ok that's an reasonable answer for "why".
Role based is a no-go as far as I understand. There is old software which can not or at least will not be rewritten, and with role based approach it just doesnt work by some reason, as far as I understand there is some store procedures which do admin stuff or something.
That's rather strange.
You have a lot of databases around, currently users are working with local databases on single user installations without servers involved.
Database internally uses username "sysdba" in some procedures/triggers etc.
You intend to host all these Databases on a public database server.
Since none of the users are SYSDBA on that new server in each of that databases the name "sysdba" has to be changed to something different as "user1", "user2" etc.
Certainly recreate and datapump is the better solution as it is a
supported method of working with databases. In case of problems
you get reasonable error messages and you can find help in solving
that.
Binary replace of username "sysdba" may work, but it may also
have side effects. It is not a supported mechanism, and you might
be on your own if it results in any trouble.
There is more than 400 clients which works in own database files, so we need to support them. They are using currently local databases, which now are move on a public server, and they need to direct access them from anywhere.
Do you really expect that to work without modifying client software?
As you use v2.5 there is no wire encryption available and a VPN is a good idea.
When connecting "from anywhere" performance might degenerate due
to higher latency in connection. V3 is more efficient on that than
v2.5
So far we were doing this user thingy from IBExpert by extracting the data and pushing it back to a new database with proper credentials.Yet for a large databases this is more than a pain, and with the crashes which occurring during the extraction and the regeneration the things is more than awful to be done at the moment.
Perhaps it is a good idea to ask for help on that trouble.
That's why I were looking for more convenient and fast way to do it.
Seems like my problem is more than well known problem with practically hit-the-wall solutions which may or may not works, and usually all requests for help like mine as far as i saw were whiteknighted by "read the documentation" answers in the forums, and the documentation usually face again the wall with this post : https://www.firebirdfaq.org/faq108/
This sends me to the idea of manually binary replacement in the file, and here I am.That's all more or less.
All answers on the list tend to direct you to consider going a direct way.
Elmar