Question : We have a username that was recently renamed from one username to another (think getting married). The Active […]
Category: Security
Postgres permission for EXPLAIN
Question : I would like to give user a permission to perform EXPLAIN but not to execute the SELECT itself. […]
pre login initialization =29237; handshake=26244
Question : Connecting to one of my servers (no mirror or availability group running), from a local machine and I […]
Is encrypted database possible?
Question : I’m not a DBA but I’ve been asked to see if we can encrypt the data in sql […]
How to Ensure of Data MariaDB Galera Cluster’s Safety?
Question : MariaDB will send a copy of SST to every server which request for it even without checking whether […]
How can I give a group of developers the ability to view the query plan, without the ability to run a trace or to view the server state?
Question : I have a group of 5 developers that need to be able to view the plans of queries […]
How to configure encrypted SQL Server connections to prevent MITM attacks?
Question : It has come to my surprise that SQL Server by default does nothing to prevent man-in-the-middle attacks when […]
What is effective permission if windows user is added as login as well as via group membership; with only public permission given via the user login?
Question : Link: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/determining-effective-database-engine-permissions?view=sql-server-ver15#principals Remember that a Windows user might be a member of more than one Windows group (e.g. […]
Set Default Maximum Rows for Export
Question : I am more of a Vertica database user than admin, so I’m not even sure if what I’m […]
What are the consequences of dropping or changing the user name for the postgres DB account?
Question : I feel confident I understand what’s involved at the db level: If dropping, I’d need to create users […]