V-271186
Microsoft SQL Server 2022 Database Security Technical Implementation Guide
Title
SQL Server must enforce discretionary access control (DAC) policies, as defined by the data owner, over defined subjects and objects.
Description
<VulnDiscussion>DAC is based on the notion that individual users are "owners" of objects and therefore have discretion over who should be authorized to access the object and in which mode (e.g., read or write). Ownership is usually acquired because of creating the object or via specified ownership assignment. DAC allows the owner to determine who will have access to objects they control. An example of DAC includes user-controlled table permissions. When discretionary access control policies are...
Fix Text (Documentation Requirement)
To correct object ownership: ALTER AUTHORIZATION ON <Securable> TO <Principal> To revoke any unauthorized permissions: REVOKE [Permission] ON <Securable> FROM <Principal>