alter superuser

ALTER ROLE role_specification | ALL } [ IN DATABASE database_name ] SET ... SUPERUSER NOSUPERUSER CREATEDB NOCREATEDB C...

alter superuser

ALTER ROLE role_specification | ALL } [ IN DATABASE database_name ] SET ... SUPERUSER NOSUPERUSER CREATEDB NOCREATEDB CREATEROLE ... ,SUPERUSER NOSUPERUSER. 這個子句決定新角色是否為「 ... 它不適用於由CREATE ROLE 和ALTER ROLE 設定的特殊角色屬性。例如,即使設定了INHERIT, ...

相關軟體 PostgreSQL 資訊

PostgreSQL
PostgreSQL 是一個跨平台的對象關係型數據庫管理系統,自 1995 年首次發布以來,已經成長為國際知名的解決方案,可幫助管理員輕鬆創建,組織,管理和部署各種形狀和大小的項目數據庫。這當然包括對運行 SQL 查詢,觸發管理,屬性管理以及其他企業級數據庫管理系統當前正在使用的所有功能的全面控制。為使日常管理多個作業和項目組件的管理員更容易訪問,PostgreSQL 符合大多數 SQL 2008... PostgreSQL 軟體介紹

alter superuser 相關參考資料
21.2. Role Attributes - PostgreSQL 正體中文使用手冊

A database superuser bypasses all permission checks, except the right to log in. ... However, to create, alter, drop, or change membership of a superuser role, ...

https://docs.postgresql.tw

ALTER ROLE - PostgreSQL 正體中文使用手冊

ALTER ROLE role_specification | ALL } [ IN DATABASE database_name ] SET ... SUPERUSER NOSUPERUSER CREATEDB NOCREATEDB CREATEROLE ...

https://docs.postgresql.tw

CREATE ROLE - PostgreSQL 正體中文使用手冊

SUPERUSER NOSUPERUSER. 這個子句決定新角色是否為「 ... 它不適用於由CREATE ROLE 和ALTER ROLE 設定的特殊角色屬性。例如,即使設定了INHERIT, ...

https://docs.postgresql.tw

Documentation: 10: 21.2. Role Attributes - PostgreSQL

A database superuser bypasses all permission checks, except the right to log in. ... However, to create, alter, drop, or change membership of a superuser role, ...

https://www.postgresql.org

Documentation: 9.0: ALTER ROLE - PostgreSQL

Roles having CREATEROLE privilege can change any of these settings, but only for non-superuser roles. Ordinary roles can only change their own password.

https://www.postgresql.org

Documentation: 9.0: Role Attributes - PostgreSQL

However, to create, alter, drop, or change membership of a superuser role, superuser status is required; CREATEROLE is insufficient for that. password.

https://www.postgresql.org

Documentation: 9.1: ALTER ROLE - PostgreSQL

Synopsis. ALTER ROLE name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE ...

https://www.postgresql.org

Documentation: 9.5: ALTER ROLE - PostgreSQL

ALTER ROLE role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE ...

https://www.postgresql.org

How to Change a User to Superuser in PostgreSQL | Tutorial ...

Learn how to change a user to a superuser in a PostgreSQL database. In this tutorial, we'll explore the power of the ALTER USER command so you can easily ...

https://chartio.com

postgres: upgrade a user to be a superuser? - Stack Overflow

ALTER USER myuser WITH SUPERUSER;. You can read more at the Documentation.

https://stackoverflow.com