{"id":1147,"date":"2022-03-11T14:46:01","date_gmt":"2022-03-11T17:46:01","guid":{"rendered":"https:\/\/gladiston.net.br\/?p=1147"},"modified":"2022-07-13T16:06:51","modified_gmt":"2022-07-13T19:06:51","slug":"como-fazer-backup-e-ou-transferencia-das-contas-de-usuarios-no-firebirdsql","status":"publish","type":"post","link":"https:\/\/gladiston.net.br\/en\/como-fazer-backup-e-ou-transferencia-das-contas-de-usuarios-no-firebirdsql\/","title":{"rendered":"How to backup and\/or transfer user accounts in FirebirdSQL"},"content":{"rendered":"<p>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<p>With the user accounts on our workstation we can change all of their real passwords to say,\u00a0<strong>masterkey<\/strong>\u00a0and 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<p>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<p>See more at:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-gladiston-santana wp-block-embed-gladiston-santana\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"4cnHGhPQHT\"><a href=\"https:\/\/gladiston.net.br\/en\/banco-de-dados\/como-fazer-backup-e-ou-transferencia-das-contas-de-usuarios\/\">How to backup and\/or transfer user accounts<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u201cHow to Backup and\/or Transfer User Accounts\u201d \u2014 Gladiston Santana\" src=\"https:\/\/gladiston.net.br\/banco-de-dados\/como-fazer-backup-e-ou-transferencia-das-contas-de-usuarios\/embed\/#?secret=iG7FpDh0HX#?secret=4cnHGhPQHT\" data-secret=\"4cnHGhPQHT\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>","protected":false},"excerpt":{"rendered":"<p>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,\u00a0masterkey\u00a0e [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"templates\/template-full-width.php","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1147","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts\/1147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/types\/post"}],"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=1147"}],"version-history":[{"count":1,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts\/1147\/revisions"}],"predecessor-version":[{"id":1148,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts\/1147\/revisions\/1148"}],"wp:attachment":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/media?parent=1147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/categories?post=1147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/tags?post=1147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}