本文介绍RDS PostgreSQL高权限账号和普通账号的权限。
| 权限 | 高权限账号 | 普通权限账号 |
|---|---|---|
| CREATEDB | ✔️ | ❌ |
| CREATEROLE | ✔️ | ❌ |
| REPLICATION | ✔️ | ❌ |
| SELECT | ✔️ | ✔️ |
| INSERT | ✔️ | ✔️ |
| UPDATE | ✔️ | ✔️ |
| DELETE | ✔️ | ✔️ |
| TRUNCATE | ✔️ | ✔️ |
| REFERENCES | ✔️ | ✔️ |
| TRIGGER | ✔️ | ✔️ |
| CREATE | ✔️ | ✔️ |
| CONNECT | ✔️ | ✔️ |
| TEMPORARY | ✔️ | ✔️ |
| EXECUTE | ✔️ | ✔️ |
| USAGE | ✔️ | ✔️ |
说明 如果您需要对账号权限进行精细化管理，请参见RDS PostgeSQL权限管理最佳实践。
