Should I drop dbo from the database role db_owner?

14 votes

2 answers

5711 views

sql-server security azure-sql-database vulnerability-assessment

                          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 it? And is there any risk?

Thanks

Asked by DBALUKE HUANG (439 rep)

Feb 3, 2021, 12:57 AM
Last activity: Jun 16, 2021, 08:05 AM

Should I drop dbo from the database role db_owner?

Related Questions