Question : How can we protect data on my database which is MySQL form database administrator stealing it? Will encrypting […]
Category: Security
Linked server only works if I am on the machine itself. I can’t use it from my local computer. what is missing?
Question : I have a few queries that I use to monitor log shipping. Sometimes I want to run those […]
DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Best practices to secure mysql
Question : I don’t have that much knowledge about mysql and i would like to secure a MySQL server. We […]
What function quotes an identifier in dynamic-sql with SQL Server?
Question : What is the SQL Server method of safe-quoting identifiers for dynamic sql generation. MySQL has quote_identifier PostgreSQL has […]
Block user access to certain tables
Question : DBMS allows the admin to grant table access to a user using something like: GRANT ALL ON mydb.mytbl1, […]
How to grant permissions to allow anything inside a SQL Server schema?
Question : I have a schema called training. I have a new role called training_modify. Here are the desired permissions […]
What are the minimal MySQL grants for the debian-sys-maint user?
Question : What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly? This answer on […]
Windows Storage Server, SQL Server, regular files — means to protect from insider threats?
Question : This is my first post here, and I am by no means qualified as a Windows Server or […]
Data sensitivity classification in SQL Server 2019
Question : Is there any way in SQL Server 2019 to physically partition data by Data Sensitivity Classification and thereby […]