Blog Posts by Jeevan Chalke
Managing Roles with Password Profiles: Part 3
Apr 16, 2019

Here in this blog, I’ll explain some new parameters for password profiles like PASSWORD_REUSE_TIME, PASSWORD_REUSE_MAX, and PASSWORD_ALLOW_HASHED...

Reset Password
Managing Roles with Password Profiles: Part 2
Apr 9, 2019

In Part 1, I have explained how FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME can be used to record user logins. In this post, I will explain how to...

Managing Roles with Password Profiles: Part 1
Apr 2, 2019

What is a Password Profile? Have you seen pop-up messages saying, "You are left with two more attempts" when you enter a wrong password? Also, have...

Planet image
How to work with Nested Subprocedures in PostgreSQL
Aug 14, 2018

As the name suggests, a nested subprocedure allows us to write a function or procedure nested within another function or procedure. It means a function can have another function within it, just like its own variable. And, as this inner function is part of the outer function, it has no visibility outside the function that encloses it.