Question : I have seen many articles regarding OPENROWSET using integrated security (Windows Authentication), but I could not make it […]
Category: Security
Restricting Database Access/Functions to User Groups?
Question : We’ve been having issues with Databases being DROPed or RESTOREd WITH REPLACE with the incorrect backup etc… I’m […]
Login failed for user NT AUTHORITYIUSR
Question : I have some developer colleagues in my office that are having a problem similar to this one: db […]
SQL Connector for Azure Key Vault – Cannot use more than one key vault
Question : I am using SQL Server 2016 Enterprise Edition with SQL Connector for Azure Key Vault. I am trying […]
MySQL secure random string generator
Question : I am looking to generate a cryptographically secure string for password reset in MySQL. I know I could […]
What are the implications of changing the SQL Server Service Logon Account?
Question : What are the implications of changing the SQL Server Service Logon Account? My default instance currently uses Network […]
Security Concerns of SQL Server Express for Web e-Voting web application
Question : I am building a database driven web application. The web application is basically an E-Voting website, where users […]
Debugging SSAS Timeouts
Question : I have a drill-through problem apparently related to security. Users in one role are seeing timeout failures when […]
Find all uses without User Mappings [duplicate]
Question : This question already has answers here: Find orphaned users (3 answers) Closed 5 years ago. I am looking […]
Is common_schema safe?
Question : I just ran across common_schema, a utility for MySQL database administrators. It is a SQL script that creates […]