{"id":43781,"date":"2022-08-11T08:00:00","date_gmt":"2022-08-11T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=43781"},"modified":"2024-04-19T10:39:51","modified_gmt":"2024-04-19T17:39:51","slug":"microsoft-purview-access-policies-for-sql-server-2022","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/","title":{"rendered":"Microsoft Purview access policies for SQL Server 2022"},"content":{"rendered":"\n<p><em>Part of the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/tag\/sql-server-2022-blogging-series\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022 blog series<\/a>.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"overview\">Overview<\/h2>\n\n\n\n<p>Microsoft Purview is a family of data governance, risk, and compliance solutions that help organizations:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gain visibility into data assets across your organization. Data assets can be across data centers, multicloud, and software as a service (SaaS) data.<\/li>\n\n\n\n<li>Enable secure access to your data.<\/li>\n\n\n\n<li>Safeguard and manage sensitive data across clouds, apps, and endpoints.<\/li>\n\n\n\n<li>Manage data risks and regulatory compliance end-to-end.<\/li>\n\n\n\n<li>Empower your organization to govern, protect, and manage data in new, comprehensive ways.<\/li>\n<\/ul>\n\n\n\n<p>The focus of this article is on using Microsoft Purview to enable access to user data as well as specific system metadata in SQL Server 2022 running on Azure Arc\u2013enabled servers.<\/p>\n\n\n\n<p>With the <a href=\"https:\/\/info.microsoft.com\/ww-landing-sql-server-2022.html\">SQL Server 2022 release<\/a>, the goal is to enable three main scenarios:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Browsing data in user-defined tables and views.<\/li>\n\n\n\n<li>Performance monitoring with system commands, functions, and views.<\/li>\n\n\n\n<li>Security auditing with security-related system functions and views.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-it-works\">How it works<\/h2>\n\n\n\n<p>To complete these scenarios the data owner first needs to author a policy. A purview policy is a set of purview statements, each containing a purview role, scope, and assigned Azure AD principal.<\/p>\n\n\n\n<p>Depending on the scenario, a purview role would be one of the built-in roles: Read, SQL Performance Monitor, or SQL Security Auditor.<\/p>\n\n\n\n<p>With scope, the policy author defines an applicable target for the statement. It could be either a specific SQL Server or a wider scope like a resource group or a subscription.<\/p>\n\n\n\n<p>To apply the policy, the author then needs to publish it to the target resources. One thing to keep in mind here is that it takes a couple of minutes for a policy to become active as it takes that much time for the SQL engine to pull it in.<\/p>\n\n\n\n<p>Once the policy is active, the assigned users will be able to connect and perform actions assigned by the policy. The Connect permission is implicit, so there is no need to create logins or database users using T-SQL.<\/p>\n\n\n\n<p>Let\u2019s see this in a more visual fashion using the scenario walkthrough.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"scenario-walkthrough\">Scenario walkthrough<\/h2>\n\n\n\n<p>For SQL Server to be able to use policies, it needs to be registered with a Microsoft Purview account and enabled for <em>Data use management<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\" alt=\"Microsoft Purview form showing the Name, Azure subscription.\" class=\"wp-image-43787 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-300x148.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-768x380.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-800x396.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-400x198.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1.webp 1334w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\"><\/figure>\n\n\n\n<p>In this scenario, Ana, who is an IT manager, wants to provide Chris, who is a data analyst, read-only access to tables in a SQL Server database so that Chris can create reports.<\/p>\n\n\n\n<p>To accomplish this, Ana authors a policy that will allow Chris access to the target server.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-2.webp\" alt=\"Access Control Policy form showing the Name, Description, and Policy statements sections filled out. \" class=\"wp-image-43790 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-2.webp\"><\/figure>\n\n\n\n<p>When finished, Ana publishes this policy and applies it to SQL Server by publishing it.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-3.webp\" alt=\"Policy publish form showing FinanceSQLonArc selected.\" class=\"wp-image-43793 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-3.webp\"><\/figure>\n\n\n\n<p>Now Chris can connect to the SQL Server and execute&nbsp;queries against the server to which the policies are applied.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-4.webp\" alt=\"SQL Query showing actions taken previously to get user connected to SQL Server without explicit login.\" class=\"wp-image-43796 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-4.webp\"><\/figure>\n\n\n\n<p>As highlighted above, Chris&nbsp;could connect to SQL Server even though there is no explicit login.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p>The new access policies feature provides data owners the capability to author access policies through the Microsoft Purview data-governance service experience and then apply them to SQL Server 2022 data sources individually or at scale. With this approach users are empowered to assign permissions to Azure Active Directory users at a scale without using T-SQL or the need to explicitly create logins or users on a server. In this release, the following server roles are eligible for assignment: Read, SQL Performance Monitor, and SQL Security Auditor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"next-steps\">Next steps<\/h2>\n\n\n\n<p>Microsoft Purview access policies for SQL Server 2022 are just one of the many benefits of migrating to SQL Server 2022.<\/p>\n\n\n\n<p><a href=\"https:\/\/aka.ms\/getsqlserver2022\">Download the latest release<\/a> of SQL Server 2022 if you haven\u2019t already done so and check out the SQL Server 2022 Overview and What\u2019s New references. There are many new features and improved functionality being added to this release.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\">Learn More<\/h2>\n\n\n\n<p>For more information and to get started, check out the following references:<\/p>\n\n\n\n<p>Read <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2022\" target=\"_blank\" rel=\"noreferrer noopener\">What\u2019s New in SQL Server 2022<\/a><\/p>\n\n\n\n<p>To learn more about Microsoft Purview check out <a href=\"https:\/\/docs.microsoft.com\/en-us\/purview\/purview\" target=\"_blank\" rel=\"noreferrer noopener\">What is Microsoft Purview? | Microsoft Docs<\/a>.<\/p>\n\n\n\n<p>For a detailed how-to on Microsoft Purview access policies for SQL Server 2022 visit <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/purview\/how-to-data-owner-policies-arc-sql-server?branch=release-build-purview-sql-policy\" target=\"_blank\" rel=\"noreferrer noopener\">Provision access by data owner for SQL Server on Azure Arc-enabled servers (preview) &#8211; Microsoft Purview | Microsoft Docs<\/a>.<\/p>\n\n\n\n<p>To see how Microsoft Purview access policies could be published at scale see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/purview\/how-to-data-owner-policies-resource-group\" target=\"_blank\" rel=\"noreferrer noopener\">Resource group and subscription access provisioning by data owner (preview) &#8211; Microsoft Purview | Microsoft Docs<\/a>.<a id=\"_msocom_10\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The focus of this article is on using Microsoft Purview to enable access to user data as well as specific system metadata in SQL Server 2022.<\/p>\n","protected":false},"author":6189,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_force_push":false,"ms_queue_id":"","ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[5278],"product":[5227,3645],"content-type":[2448],"topic":[2460],"coauthors":[5108],"class_list":["post-43781","post","type-post","status-publish","format-standard","hentry","tag-sql-server-2022-blogging-series","product-sql","product-sql-server-2022","content-type-updates","topic-data-security","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Purview access policies for SQL Server 2022 - Microsoft SQL Server Blog<\/title>\n<meta name=\"description\" content=\"Microsoft Purview data governance empowers data owners to author and apply access policies to data sources and assign permissions to users at scale.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Purview access policies for SQL Server 2022 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Microsoft Purview data governance empowers data owners to author and apply access policies to data sources and assign permissions to users at scale.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-11T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-19T17:39:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\" \/>\n<meta name=\"author\" content=\"Srdan Bozovic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Srdan Bozovic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/srdan-bozovic\/\",\"@type\":\"Person\",\"@name\":\"Srdan Bozovic\"}],\"headline\":\"Microsoft Purview access policies for SQL Server 2022\",\"datePublished\":\"2022-08-11T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:39:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\"},\"wordCount\":715,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\",\"keywords\":[\"SQL Server 2022 Blogging Series\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\",\"name\":\"Microsoft Purview access policies for SQL Server 2022 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\",\"datePublished\":\"2022-08-11T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:39:51+00:00\",\"description\":\"Microsoft Purview data governance empowers data owners to author and apply access policies to data sources and assign permissions to users at scale.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Purview access policies for SQL Server 2022\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Purview access policies for SQL Server 2022 - Microsoft SQL Server Blog","description":"Microsoft Purview data governance empowers data owners to author and apply access policies to data sources and assign permissions to users at scale.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Purview access policies for SQL Server 2022 - Microsoft SQL Server Blog","og_description":"Microsoft Purview data governance empowers data owners to author and apply access policies to data sources and assign permissions to users at scale.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2022-08-11T15:00:00+00:00","article_modified_time":"2024-04-19T17:39:51+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp","type":"","width":"","height":""}],"author":"Srdan Bozovic","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Srdan Bozovic","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/srdan-bozovic\/","@type":"Person","@name":"Srdan Bozovic"}],"headline":"Microsoft Purview access policies for SQL Server 2022","datePublished":"2022-08-11T15:00:00+00:00","dateModified":"2024-04-19T17:39:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/"},"wordCount":715,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp","keywords":["SQL Server 2022 Blogging Series"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/","name":"Microsoft Purview access policies for SQL Server 2022 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp","datePublished":"2022-08-11T15:00:00+00:00","dateModified":"2024-04-19T17:39:51+00:00","description":"Microsoft Purview data governance empowers data owners to author and apply access policies to data sources and assign permissions to users at scale.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/08\/179551_Figure-1-1024x507.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/11\/microsoft-purview-access-policies-for-sql-server-2022\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft Purview access policies for SQL Server 2022"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/43781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6189"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=43781"}],"version-history":[{"count":3,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/43781\/revisions"}],"predecessor-version":[{"id":50688,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/43781\/revisions\/50688"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=43781"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=43781"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=43781"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=43781"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=43781"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=43781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}