{"id":218,"date":"2024-08-19T13:58:13","date_gmt":"2024-08-19T05:58:13","guid":{"rendered":"http:\/\/www.bigqq.com\/?p=218"},"modified":"2025-04-10T09:57:39","modified_gmt":"2025-04-10T01:57:39","slug":"pg%e6%b7%bb%e5%8a%a0%e5%8d%95%e4%b8%aa%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%93%e7%94%a8%e8%b4%a6%e6%88%b7","status":"publish","type":"post","link":"http:\/\/www.bigqq.com\/?p=218","title":{"rendered":"PG\u6dfb\u52a0\u5355\u4e2a\u6570\u636e\u5e93\u4e13\u7528\u8d26\u6237"},"content":{"rendered":"\n

CREATE<\/strong> ROLE<\/strong> xxx NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN NOREPLICATION NOBYPASSRLS PASSWORD<\/strong> ‘xxxxxpwd’<\/strong>;<\/p>\n\n\n\n

ALTER<\/strong> DATABASE<\/strong> “xx”<\/strong> OWNER<\/strong> TO<\/strong> xxx;<\/p>\n\n\n\n

GRANT<\/strong> ALL<\/strong> ON<\/strong> SCHEMA<\/strong> public TO<\/strong> xxx;<\/p>\n\n\n\n

Grant<\/strong> all<\/strong> on<\/strong> all<\/strong> tables<\/strong> in<\/strong> schema<\/strong> public to<\/strong> xxx;<\/p>\n\n\n\n

select<\/strong> ‘ALTER TABLE ‘<\/strong> || table_name<\/em><\/strong> || ‘ OWNER TO wf;’<\/strong> from<\/strong> information_schema.tables<\/strong> where<\/strong> table_schema<\/em><\/strong>=‘public’<\/strong>;<\/p>\n\n\n\n

\u6216\u8005<\/p>\n\n\n\n

select<\/strong> case<\/strong> WHEN<\/strong> relkind<\/em><\/strong>= ‘r’<\/strong> then<\/strong><\/p>\n\n\n\n

‘ALTER TABLE ‘<\/strong>||relname<\/em><\/strong>||‘ owner to oa;’<\/strong><\/p>\n\n\n\n

else<\/strong><\/p>\n\n\n\n

‘ALTER SEQUENCE ‘<\/strong>||relname<\/em><\/strong>||‘ owner to oa;’<\/strong><\/p>\n\n\n\n

end<\/strong> from<\/strong> pg_class<\/em><\/strong> where<\/strong> relkind<\/em><\/strong> in<\/strong> (‘r’<\/strong>,‘S’<\/strong>);<\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE ROLE xxx NOSU […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/218"}],"collection":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=218"}],"version-history":[{"count":2,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":310,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions\/310"}],"wp:attachment":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}