Skip to content

Latest commit

 

History

History
44 lines (29 loc) · 1.83 KB

view-the-policy-based-management-facets-on-a-sql-server-object.md

File metadata and controls

44 lines (29 loc) · 1.83 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
View Policy-Based Management facets on an object
Describes how to view all of the Policy-Based Management facts applied to a specific SQL Server object in SQL Server Management Studio (SSMS).
VanMSFT
vanto
03/14/2017
sql
security
how-to
Policy-Based Management, view facets

View Policy-Based Management facets on a SQL Server Object

[!INCLUDE SQL Server] This topic describes how to view all of the Policy-Based Management facets applied to a specific SQL Server object in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull].

In This Topic

Before You Begin

Security

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

Using SQL Server Management Studio

To view all of the facets in an object

  1. In Object Explorer, right-click an instance of [!INCLUDEssNoVersion], instance object, database, or database object, and then click Facets.

  2. In the View Facets -object_name dialog box, in the Facet list, select a facet to view its properties. For more information on the available options in this dialog box, see View Facets Dialog Box.

  3. When finished, click OK.