This topic describes the permissions of the privileged account and standard account that are created on an ApsaraDB RDS for PostgreSQL instance.

Permission Privileged account Standard account
CREATEDB ✔️
CREATEROLE ✔️
REPLICATION ✔️
SELECT ✔️ ✔️
INSERT ✔️ ✔️
UPDATE ✔️ ✔️
DELETE ✔️ ✔️
TRUNCATE ✔️ ✔️
REFERENCES ✔️ ✔️
TRIGGER ✔️ ✔️
CREATE ✔️ ✔️
CONNECT ✔️ ✔️
TEMPORARY ✔️ ✔️
EXECUTE ✔️ ✔️
USAGE ✔️ ✔️
Note In the preceding table, ticks (√) indicate that an account has the permission and crosses (×) indicate that an account does not have the permission.