Enhanced security: Logging PostgreSQL connections
Logging connections in PostgreSQL can be incredibly valuable for monitoring and troubleshooting purposes. However, that’s not all: auditing is also […]
PostgreSQL to Microsoft Excel via Npgsql
Find out how you can integrate and store the use of data in PostgreSQL from Excel with Npgsql. For all Excel heroes here.
PostgreSQL ALTER DEFAULT PRIVILEGES - permissions explained
by
Laurenz Albe |
05.2023 Many people have heard that ALTER DEFAULT PRIVILEGES makes it easy to allow other users access to tables. But […]
PostgreSQL ERROR: permission denied for schema public
Public schema default permissions changed in PostgreSQL 15 - it might hurt you during application deployment. Here's what to do.
View permissions and row-level security in PostgreSQL
by
Laurenz Albe |
06.2022 The details of how view permissions are checked have long puzzled me. PostgreSQL v15 introduces “security invoker” views, which […]
PostgreSQL Security: 12 rules for database hardening
UPDATED August 2023: PostgreSQL security - make your database safe. Follow these 12 recommendations for proactive database hardening.
From MD5 to scram-sha-256 in PostgreSQL
by
Laurenz Albe |
06.2021 Since v10, PostgreSQL has provided support for scram-sha-256 for password hashing and authentication. This article describes how you can […]
PostgreSQL: Get member roles and permissions
PostgreSQL allows you to define users (=roles), groups, etc. This post explains how to retrieve information on roles & role membership.
Using “Row Level Security” to make large companies more secure
How to use row level security to restrict internal access to PostgreSQL databases. How to configure access restrictions dynamically.
PostgreSQL Row Level Security, views and a lot of magic
How to implement row-level security in PostgreSQL and views. Shows examples and corner cases to watch out for.
