Skip to content

Latest commit

 

History

History
31 lines (22 loc) · 1.05 KB

File metadata and controls

31 lines (22 loc) · 1.05 KB
title Trustworthy Bit
description Trustworthy Bit
author VanMSFT
ms.author vanto
ms.date 12/15/2023
ms.service sql
ms.subservice security
ms.topic reference
helpviewer_keywords
Best Practices [Database Engine]

Trustworthy bit

[!INCLUDE SQL Server]

This rule determines whether the dbo role for a database is assigned to the sysadmin fixed server role and the database has its trustworthy bit set to ON.

If these conditions are met, a privileged database user can elevate privileges to the sysadmin role. In this role, the user can create and run unsafe assemblies that compromise the system.

Best practices recommendations

Turn off the trustworthy bit or revoke sysadmin permissions from the dbo database role.

For more information

ALTER DATABASE (Transact-SQL)

Related content