在 Google Cloud 中将用户升级为超级用户的步骤

Question

我如何在Google Cloud Console中创建具有超级用户角色的Postgres服务器用户？

在Google Cloud中创建数据库时，默认用户是非超级用户。从此角色无法升级。

- Troels

Answer 1

不可能:

https://cloud.google.com/sql/docs/postgres/users

postgres用户是cloudsqlsuperuser角色的一部分，具有以下属性（特权）：CREATEROLE、CREATEDB和LOGIN。它没有SUPERUSER或REPLICATION属性。

- Vao Tsun

---

谢谢。我看了，但我希望有一种方法可以把它困住，也许是通过连接到谷歌云的PowerShell。 :-) - Troels

真的吗？不可能吧？ - Carles Figuera

更新一下：我从Google Cloud Postgres转换到了VS，并在其中安装了Postgres。现在它运行得非常好。 - Troels

Answer 2

这是我的脚本：

GRANT cloudsqlimportexport, cloudsqlsuperuser, pg_read_all_data, pg_write_all_data, postgres TO myawsumuser WITH ADMIN OPTION;

GRANT ALL PRIVILEGES ON DATABASE mytestdb1 TO myawsumuser WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON DATABASE postgres TO myawsumuser WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myawsumuser with grant option;
GRANT USAGE ON SCHEMA public TO myawsumuser with grant option;

GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myawsumuser with admin option;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myawsumuser with grant option;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO myawsumuser with grant option;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO myawsumuser with grant option;

好的链接： https://cloud.google.com/sql/docs/postgres/users

如何将所有视图的权限授予任意用户

- JDOaktown