Question : I’m new to postgres. It might sound a silly question, due to some security requirement I need to […]
Category: Security
Dropping the automatically created NT AUTHORITY and NT SERVICE accounts
Question : So I recently moved jobs – one piece of code I’ve spotted in our build scripts for new […]
How do I identify the program that called a stored procedure?
Question : As part of an application database design spec, we’ve been asked to block execution of a set of […]
CREATE ASSEMBLY System.DirectoryServices.AccountManagement.dll without enabling TRUSTWORTHY
Question : First, this is for SQL Server 2016. If I was on 2017+, I would be using sp_add_trusted_assembly. Just […]
What is the equivalent of a “Certificate of Destruction” when using a cloud-hosted database?
Question : We have a Rails application hosted by Heroku and using an Heroku Postgres database. Some of the information […]
How to add a new listener on a new port and restrict it to one instance only
Question : I am running oracle 11.2.3 and we have a server with multiple instances running. All of them are […]
Postgres RLS: how to error instead of ignoring rows not matched by the policy? [duplicate]
Question : This question already has an answer here: Log occurrences when Row Level Security Policies filter out rows (1 […]
DELAYED User at MySQL
Question : mysql> show processlist; | Id | User | Host | db | Command | Time | State | […]
Restrict Oracle DB Login based on SQL Client being used
Question : We have an application in our organization that is based on Oracle Forms 11g (on Oracle Fusion Middleware/WLS). […]
Can ransomware embed itself in to a SQL backup file?
Question : One of the best protections against ransomware is to back up all of your database files to a […]