Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

IntermediateAdvanced PostgreSQL

Grant table permissions

SQL

GRANT SELECT, INSERT, UPDATE ON employees TO app_user;

Tested against PostgreSQL 16

Note

“Gives specific privileges on a table to a role. Essential for principle of least privilege.