CYBERTEC PostgreSQL Logo

Tag: security

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: security.
You can go back to all blog posts or take a look into our other categories & tags.

Abusing SECURITY DEFINER functions in PostgreSQL

by Laurenz Albe | 05.2019
UPDATED August 2023: Functions defined as SECURITY DEFINER are a powerful, but dangerous tool in PostgreSQL. The documentation warns of […]

Security and PostgreSQL - a reminder on various attack surfaces

by CYBERTEC Guest | 04.2019
This article gives an overview about common security problems as well as ways to mitigate these risks in PostgreSQL.

pg_permissions: Inspecting your PostgreSQL security system

by Hans-Jürgen Schönig | 01.2019
pg_permissions is a tool display the security settings of your database. Get a quick overview of what's going on inside your security.

Security matters - hiding a table column - restrict column access

by CYBERTEC Guest | 12.2017
How to restrict column access. The best option for hiding table columns in a non-destructive way is the rule system.

Detecting fraud: Benford's law

by Hans-Jürgen Schönig | 01.2014
Benford's law is a mechanism, which is widely used in many fields. Especially accounting fraud can be detected nicely using this simple law of mathematics.

Security barriers: Cheating on the planner

by Hans-Jürgen Schönig | 12.2013
UPDATED Aug. 2023 - How a security barrier can theoretically be used to speed up PostgreSQL queries and to see how PG works under the hood.

Common security issues prior to PostgreSQL 15

by Hans-Jürgen Schönig | 10.2013
UPDATED July 2023: How to avoid security issues in PostgreSQL prior to v15 due to the public schema. Repair the problem.
1 2
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2025
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram