postgresql rename postgres user

postgresql rename postgres user

• 軟體兄弟
• postgresql change password
• 文章資訊

Synopsis. ALTER USER name [ [ WITH ] option [ ... ] ] where option can be: CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'abstime' ALTER USER name RENAME TO newname ALTER ,... ALTER USER name RENAME TO new_name ALTER USER role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter TO | = } value | DEFAULT } ALTER USER role_specification | ALL } [ IN DATABASE database_name ] SET configuration_par,... LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | CONNECTION LIMIT connlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' ALTER USER name RENAME TO new_name ALTER USER name | ALL } [ IN DATABASE database_n,... 'password' | VALID UNTIL 'timestamp' ALTER USER name RENAME TO new_name ALTER USER name SET configuration_parameter TO | = } value | DEFAULT } ALTER USER name SET configuration_parameter FROM CURRENT ALTER USER name RESET configurati,Database superusers can rename any role. Roles having CREATEROLE privilege can rename non-superuser roles. The current session user cannot be renamed. (Connect as a different user if you need to do that.) Because MD5-encrypted passwords use the role name ,... LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | CONNECTION LIMIT connlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' ALTER USER name RENAME TO new_name ALTER USER name | ALL } [ IN DATABASE database_n,... ALTER USER name RENAME TO new_name ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter TO | = } value | DEFAULT } ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT ALTER USER name [ IN DATAB,Database superusers can rename any role. Roles having CREATEROLE privilege can rename non-superuser roles. The current session user cannot be renamed. (Connect as a different user if you need to do that.) Because MD5-encrypted passwords use the role name ,This PostgreSQL tutorial explains how to rename a user in PostgreSQL with syntax and examples. The ALTER USER statement is used to rename a user in the PostgreSQL database.

相關軟體 PostgreSQL 資訊

PostgreSQL 是一個跨平台的對象關係型數據庫管理系統，自 1995 年首次發布以來，已經成長為國際知名的解決方案，可幫助管理員輕鬆創建，組織，管理和部署各種形狀和大小的項目數據庫。這當然包括對運行 SQL 查詢，觸發管理，屬性管理以及其他企業級數據庫管理系統當前正在使用的所有功能的全面控制。為使日常管理多個作業和項目組件的管理員更容易訪問，PostgreSQL 符合大多數 SQL 2008... PostgreSQL 軟體介紹 postgresql rename postgres user 相關參考資料 PostgreSQL: Documentation: 8.0: ALTER USER Synopsis. ALTER USER name [ [ WITH ] option [ ... ] ] where option can be: CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL &#3... https://www.postgresql.org PostgreSQL: Documentation: 9.5: ALTER USER ... ALTER USER name RENAME TO new_name ALTER USER role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter TO | = } value | DEFAULT } ALTER USER role_specification | AL... https://www.postgresql.org PostgreSQL: Documentation: 9.4: ALTER USER ... LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | CONNECTION LIMIT connlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' ALTER USER name RENAME TO new... https://www.postgresql.org PostgreSQL: Documentation: 9.1: ALTER USER ... 'password' | VALID UNTIL 'timestamp' ALTER USER name RENAME TO new_name ALTER USER name SET configuration_parameter TO | = } value | DEFAULT } ALTER USER name SET configuration_p... https://www.postgresql.org PostgreSQL: Documentation: 9.0: ALTER ROLE Database superusers can rename any role. Roles having CREATEROLE privilege can rename non-superuser roles. The current session user cannot be renamed. (Connect as a different user if you need to do th... https://www.postgresql.org PostgreSQL: Documentation: 9.3: ALTER USER ... LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | CONNECTION LIMIT connlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' ALTER USER name RENAME TO new... https://www.postgresql.org PostgreSQL: Documentation: 9.2: ALTER USER ... ALTER USER name RENAME TO new_name ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter TO | = } value | DEFAULT } ALTER USER name [ IN DATABASE database_name ] SET configur... https://www.postgresql.org PostgreSQL: Documentation: 9.1: ALTER ROLE Database superusers can rename any role. Roles having CREATEROLE privilege can rename non-superuser roles. The current session user cannot be renamed. (Connect as a different user if you need to do th... https://www.postgresql.org PostgreSQL: Rename a User - TechOnTheNet This PostgreSQL tutorial explains how to rename a user in PostgreSQL with syntax and examples. The ALTER USER statement is used to rename a user in the PostgreSQL database. https://www.techonthenet.com