{"id":1781,"date":"2023-09-27T15:54:06","date_gmt":"2023-09-27T13:54:06","guid":{"rendered":"https:\/\/alessandromasciadri.com\/?p=1781"},"modified":"2023-09-27T16:33:07","modified_gmt":"2023-09-27T14:33:07","slug":"come-cambiare-proprietario-a-database-postgresql","status":"publish","type":"post","link":"https:\/\/alessandromasciadri.com\/come-cambiare-proprietario-a-database-postgresql\/","title":{"rendered":"Come cambiare proprietario a database PostgreSQL"},"content":{"rendered":"\t\t<div data-akihiro-type=\"ama-post\" data-akihiro-id=\"1781\" class=\"akihiro akihiro-1781\" data-akihiro-post-type=\"post\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-ec42f31 e-flex e-con-boxed e-con e-parent\" data-id=\"ec42f31\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-21f4824 akihiro-widget akihiro-widget-text-editor\" data-id=\"21f4824\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tPostgreSQL ci consente di modificare le propriet\u00e0 di un database mediante il comando <code>ALTER DATABASE<\/code>. Possiamo cos\u00ec modificare il nome del database, i suoi attributi, il proprietario e cos\u00ec via.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-e18dc31 akihiro-widget akihiro-widget-heading\" data-id=\"e18dc31\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Modificare proprietario database Postgres<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-c759842 akihiro-widget akihiro-widget-text-editor\" data-id=\"c759842\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In Postgres, il comando <code>ALTER DATABASE<\/code> utilizza la clausola <code>OWNER TO<\/code> per cambiare\/modificare il proprietario del database. Il comando \u00e8 quindi il seguente:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8a8f980 akihiro-widget akihiro-widget-code-highlight\" data-id=\"8a8f980\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>ALTER DATABASE db_name\nOWNER TO new_owner_name;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-2aa6308 akihiro-widget akihiro-widget-text-editor\" data-id=\"2aa6308\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Una volta eseguito il comando per il cambio di owner del DB, possiamo verificare i dettagli del database, verificando cos\u00ec l&#8217;attuale proprietario, lanciando il seguente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-32c3093 akihiro-widget akihiro-widget-code-highlight\" data-id=\"32c3093\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>\\l<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-3fb4228 akihiro-widget akihiro-widget-heading\" data-id=\"3fb4228\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Note importanti<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-34e3f5b akihiro-widget akihiro-widget-text-editor\" data-id=\"34e3f5b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t\u00c8 importante tenere presente che per cambiare il proprietario di un database \u00e8 necessario avere permessi di superuser. Per eseguire questa operazione si consiglia pertanto di collegarsi al db con utente <code>postgres<\/code>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>PostgreSQL ci consente di modificare le propriet\u00e0 di un database mediante il comando ALTER DATABASE. Possiamo cos\u00ec modificare il nome del database, i suoi attributi, il proprietario e cos\u00ec via. Modificare proprietario database Postgres In Postgres, il comando ALTER DATABASE utilizza la clausola OWNER TO per cambiare\/modificare il proprietario del database. Il comando \u00e8 quindi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[50],"class_list":["post-1781","post","type-post","status-publish","format-standard","hentry","category-programmazione","category-sistemistica","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/1781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/comments?post=1781"}],"version-history":[{"count":7,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/1781\/revisions"}],"predecessor-version":[{"id":1788,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/1781\/revisions\/1788"}],"wp:attachment":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/media?parent=1781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/categories?post=1781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/tags?post=1781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}