Questions tagged [vulnerability-assessment]
The vulnerability-assessment tag has no usage guidance.
9
questions
0
votes
1answer
9 views
How to setup Mysql master-slave replication with the slave meant for testing where divergence is OK
Problem:
I have a staging DB server on which functionality is tested before pushing it to the production environment. Now, we want to start doing VA/PT (Vulnerability Analysis and Penetration Testing) ...
0
votes
1answer
81 views
Should I provide db_owner principal role to the user of the Azure SQL of my Azure Web App?
I have an Azure Web App connected to an Azure SQL database. Let's call the app ACME. The application has it's own Role and User called ACME, and I gave that User db_owner principal roles. The ...
9
votes
2answers
917 views
Should I drop dbo from the database role db_owner?
I did a Vulnerability Assessment for my database today. I found VA2108 and it suggests me to
ALTER ROLE [db_owner] DROP MEMBER [dbo]
But it's the default setting of any SQL instance.
Should I go for ...
0
votes
0answers
76 views
Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE' vulnerability for Windows 2008 R2 SQL
I have a MSSQL Windows 2008 R2 server. Vulnerability for "Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE'" has been found. Current ...
4
votes
2answers
485 views
How can I run SQL Server Vulnerability Assessment from a SQL Job?
I want to run SQL Server Vulnerability Assessment from a SQL Server Agent Job. Currently, I am attempting a job with a PowerShell script and am running a command like the one below.
Invoke-...
1
vote
2answers
901 views
Incorrect “Sensitive data columns should be classified” report
Every week I'm getting a failed "Vulnerability Assessment" email report from my Microsoft Azure SQL Database that is incorrect.
It complains about columns that have is_computed column in sys.columns ...
0
votes
1answer
41 views
On what basis DMA identifies columns for Dynamic Data Masking?
Can anyone help me explain on what basis 'Data Migration Assessment' features recommendation suggests for Dynamic Data Masking and displays certain objects/tables columns for masking. On what basis ...
1
vote
0answers
85 views
SQL Vulnerability Assessment Error in PowerShell
I am running Vulnerability Assessments against my SQL Servers and databases using the PowerShell cmdlets Invoke-SqlVulnerabilityAssessmentScan and Export-SqlVulnerabilityAssessmentScan, however, I am ...
2
votes
2answers
4k views
Trying to disable xp_Cmdshell and rpc_out and and receiving mixed results
I'm trying to disable xp_Cmdshell and rpc_out and when I run the commands on query analyzer it shows it's disabled.
But after this I need to run a security scan report which provides me the following ...
