This article is more about transferring active user accounts on a server to a workstation, however, the same principle applies to a backup of user accounts. Why do?<\/p>\n\n\n\n
With the user accounts on our workstation we can change all of their real passwords to say, masterkey<\/strong> and working with them and testing real permission environments on tables, triggers, procedures and any other objects we have to GRANT. In addition, we can have the backup of the accounts, just in case of an accident and need to recover it again.<\/p>\n\n\n\n Another real scenario is when we are migrating from, for example, FirebirdSQL3 to FirebirdSQL4. Our following example will be based on this scenario.<\/p>\n\n\n\n To run the backup of \u201csecurity3.fdb\u201d you need to be using the administrator account and open the terminal with it, then you can access the FirebirdSQL folder which is protected by administrative permissions and then run:<\/p>\n\n\n\n In the example above, we made the backup. If this is your goal, now just keep the file \u201cc:\\temp\\security3.fbk\u201d in a safe place. Note in the example above that we didn't use gbak's -password PRODUCT PASSWORD parameter, why not? It is not necessary because the access in this case is embedded.<\/p>\n\n\n\n Either for any of the scenarios I mentioned at the beginning, to restore the database we will need the gbak<\/strong> of the desired version and obviously from the backup file:<\/p>\n\n\n\n Backup of user accounts has been restored!<\/p>\n\n\n\n IMPORTANT: If you are bringing production user accounts to the development environment you will need to change the SYSDBA password for security reasons, imagine the catastrophe that would be for you to enter the production base thinking you are entering the development base.<\/p>\n\n\n\n CHANGING SYSDBA PASSWORD<\/p>\n\n\n\n As of now, you have restored user accounts but want to change SYSDBA password, how to do? It's simple, first we'll need to connect to the security3.fdb base: <\/p>\n\n\n\n Then we will execute this sequence of commands changing not only the SYSDBA user's password, but if it is in a development environment, also yours and the users who want to simulate an action within the database:<\/p>\n\n\n\n The restore procedure is basically the same, what differs is the directory of FB4 which is different from FB3:<\/p>\n\n\n\n The above principle will work for any database upgrade.<\/p>\n\n\n\n It is imperative that you NEVER mix development passwords with production passwords, whether in one bank or the other. When it is necessary to bring a base to the development environment, the first thing to do is change the passwords contained therein.<\/p>\n\n\n\n Don't use the -rep option to restore a backup over the existing database, be cautious, do as I showed above, rename the old file to .bak and proceed with your restore.<\/p>\n\n\n\n The server is not \u201cMaria Joana's house\u201d, inexperienced people should not have access to the administrator account or any production server, so the backup\/restore procedure must be performed by someone experienced, perhaps pragmatic when the situation is to do things with caution and dexterity.<\/p>","protected":false},"excerpt":{"rendered":" Este artigo foi pensado mais em transferir as contas de usu\u00e1rios ativos num servidor para uma esta\u00e7\u00e3o de trabalho, no entanto, o mesmo principio de aplica a um backup das contas de usu\u00e1rios. Por que fazer? Com as contas de usu\u00e1rios em nossa esta\u00e7\u00e3o de trabalho podemos alterar todas as senhas reais deles para digamos, […]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":1109,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/template-full-width.php","meta":{"footnotes":""},"class_list":["post-1139","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/1139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/comments?post=1139"}],"version-history":[{"count":2,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/1139\/revisions"}],"predecessor-version":[{"id":2031,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/1139\/revisions\/2031"}],"up":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/1109"}],"wp:attachment":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/media?parent=1139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}BACKUP USER ACCOUNTS IN PRODUCTION<\/h2>\n\n\n\n
set path=%path%;"C:\\Program Files\\Firebird\\Firebird_3_0"\ngbak -v -b -t -user sysdba "C:\\Program Files\\Firebird\\Firebird_3_0\\security3.fdb" c:\\temp\\security3.fbk<\/pre><\/div>\n\n\n\n
RESTORING THE BACKUP OF USER ACCOUNTS<\/h2>\n\n\n\n
set path=%path%;"C:\\Program Files\\Firebird\\Firebird_3_0"\ncd "C:\\Program Files\\Firebird\\Firebird_3_0"\nren security3.fdb security3.fdb.ori\ngbak -v -r -user sysdba c:\\temp\\security3.fbk "C:\\Program Files\\Firebird\\Firebird_3_0\\security3.fdb"<\/pre><\/div>\n\n\n\n
set path=%path%;"C:\\Program Files\\Firebird\\Firebird_3_0"\nisql.exe -user SYSDBA "C:\\Program Files\\Firebird\\Firebird_3_0\\security3.fdb"\n<\/pre><\/div>\n\n\n\n
alter user SYSDBA password 'masterkey';\n-- altere outras senhas se preferir, por exemplo, equipe de desenvolvimento:\n-- afinal, n\u00e3o \u00e9 bom que a equipe de desenvolvimento tenham as mesmas senhas\n-- em produ\u00e7\u00e3o e tamb\u00e9m desenvolvimento:\nalter user MINHACONTA password 'masterkey';\nalter user DEV_USER1 password 'masterkey';\nalter user DEV_USER2 password 'masterkey';\ncommit;\nquit;\n<\/pre><\/div>\n\n\n\n
RESTORING ACCOUNT BACKUP IN FIREBIRD 4<\/h2>\n\n\n\n
set path=%path%;"C:\\Program Files\\Firebird\\Firebird_4_0"\ncd "C:\\Program Files\\Firebird\\Firebird_4_0"\nren security4.fdb security4.fdb.ori\ngbak -v -r -user sysdba c:\\temp\\security3.fbk "C:\\Program Files\\Firebird\\Firebird_4_0\\security4.fdb"<\/pre><\/div>\n\n\n\n
GOOD PRACTICES WITH BACKUP\/RESTORE<\/h2>\n\n\n\n