PostgreSQL privileges

Here’s a compact list of PostgreSQL privileges, grouped by level of application, with each privilege described in 4–6 words on the same line:

---

🔹 Database-Level Privileges

• CONNECT — Allow connect to database
• CREATE — Create schemas in database
• TEMP — Create temporary tables here

---

🔹 Schema-Level Privileges

• USAGE — Use schema and objects
• CREATE — Create objects in schema

---

🔹 Table-Level Privileges

• SELECT — Read data from table
• INSERT — Add new rows to table
• UPDATE — Modify existing rows/columns
• DELETE — Remove rows from table
• TRUNCATE — Remove all rows efficiently
• REFERENCES — Create foreign keys referencing
• TRIGGER — Create triggers on table

---

🔹 Column-Level Privileges

• SELECT — Read data from column
• UPDATE — Modify values in column

---

🔹 Sequence-Level Privileges

• USAGE — Use sequence without incrementing
• SELECT — Read current value of sequence
• UPDATE — Modify current value directly

---

🔹 Function-Level Privileges

• EXECUTE — Run the function/procedure

---

Let me know if you want examples of how to grant these at each level.