When you manage production databases, sooner or later the time comes when security and compliance requirements will knock on your door. The question is not whether you will need to record who did what, but how you will do it… read more
How to enable Data Masking in PostgreSQL
In this article we will see how we can implement data anonymization and masking in a PostgreSQL 14 database using the PostgreSQL Anonymizer extension. We will cover the installation process, setting up masking rules, as well as the specifics that… read more
How to create a Logon Trigger to control which users are allowed to connect to an Oracle Database
Many times, for security reasons, we may want specific users to connect only from specific machines - servers, and in the event that a connection comes from a different machine, not allow access but display a rejection message.… read more
How to enforce password policy in an Oracle database
As we know in an Oracle database through User Profiles we can set restrictions on user groups regarding when and if a password expires (PASSWORD_LIFE_TIME), how many days it can be changed before it stops... read more
