Data Security using Roles, Privileges and Row Level Security
summary
Lists every PostgreSQL privilege and shows which SQL error each missing grant produces, demonstrates granting connect, usage, select, insert, update, delete, truncate, execute, create, temporary and how ACLs appear via pg_class/acl_explode, describes SSL and pgcrypto client/server options, and builds three sample message‑exchange apps (Java and C, plus a pgcrypto Java variant) that use PL/pgSQL helpers like the is_friend function and row level security enabled policies to enforce who can insert or read messages; the demos run and produce the expected permission errors and successful inserts.
AI-written summary · about
chapters (11)
- 0:00Start
- 1:45Cryptography
- 4:04Public Key Encryption in Public Key Encryption
- 4:56How Do You Use the Public Key Encryption
- 11:43Secure Message Exchange
- 13:28Role System and the Row Level Security
- 15:06Revoke Privileges
- 16:24Error Permission Denied for Schema
- 23:55Row Level Security
- 24:13Sample Message Exchange Application
- 26:40Create the Sample Application
related talks
27mFor Your Eyes Only: Roles, Privileges, and Security in PostgreSQL
40mPostgreSQL Security for Application Developers
47mUntangling the Web of PostgreSQL Permissions
07mAll about Postgres security
53mRow Level Security
18mEverything you need to know about Postgres Row Level Security
28mPostgreSQL vs. SQL Server: Security Model Differences
32mEnhancing Security in PostgreSQL