January 05, 2021
A password profile is a named set of password attributes that allow a DBA to easily manage a group of Postgres roles (or users) that share comparable password requirements. Each profile can be associated with one or more users. When a user connects to the server, the server enforces the profile that is associated with the login role.
Profiles can be used for several important security best practices, including:
- specifying the number of allowable failed login attempts.
- locking an account due to excessive failed login attempts.
- marking a password for expiration.
- defining a grace period after a password expiration.
- defining rules for password complexity, and
- defining rules that limit password reuse.
Watch the video below to learn more!
You can download our whitepaper here to read more about PostgreSQL security best practices.
Relevant Blogs
The Importance of Giving Back: Analyzing Code Contributions to PostgreSQL 15
How do you choose who provides the support or deployment solution you need for your business-critical applications? An often overlooked factor is whether the company is committed to contributing upstream...Community and Open Source: The Secret to PostgreSQL’s Success
PostgreSQL is having a moment—in recent years it’s skyrocketed in popularity across industries and established itself as the go-to database for innovation leaders. It’s the first three-time winner of DBMS...
Move Your Workloads to the Public Cloud—Not Oracle’s
In recent years, more and more businesses—both industry leaders and up-and-comers—have decided to ditch their legacy commercial database in favor of open source solutions like Community PostgreSQL. With constantly rising...More Blogs
Webinar Recap: How Governments Can Expand Their Options With Open Source Software
Open source software is changing the landscape of the global database market, and the implications could be transformative for government organizations looking to make the most of their mission-critical assets...The TSG Group Promotes Clean Energy and Drives Innovation with Postgres and EDB
On January 24th, EDB General Manager and Vice President, EMEA, Herve Timsit sat down with Eric Bonnevay, CIO of the TSG Group at the French Postgres Users Club in Paris...