Lectures

In this lecture, you'll find out how the security system in PostgreSQL works: from roles and access rights to network restrictions and protection against SQL injections. We'll break down real threats, control tools, and best practices to keep your data safe.

In this lecture, you'll learn how to create and manage roles in PostgreSQL: what makes roles different from users, how to grant and revoke privileges, and how to build hierarchies and role groups for easier access management.

In this lecture, you'll learn how to manage access to PostgreSQL database objects using the GRANT and REVOKE commands. We'll check out how to give and take away rights on databases, schemas, and tables, plus show some practical examples of setting up roles for different security scenarios.

Row-Level Security (RLS) in PostgreSQL lets you restrict access to individual rows in a table based on security policies. In this lecture, you'll learn how to enable RLS, create policies for SELECT, INSERT, UPDATE, DELETE, and make sure users only see and change their own data. Examples, common mistakes, and debugging tips — everything you need for secure apps!

In this lecture, you'll learn how to use the pg_hba.conf file to manage access to your PostgreSQL server by IP addresses, roles, and databases. We'll break down the file structure, look at setup examples, common mistakes, and best practices to keep your database safe.