{"id":2883,"date":"2012-12-24T12:05:30","date_gmt":"2012-12-24T11:05:30","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/"},"modified":"2012-12-24T12:05:30","modified_gmt":"2012-12-24T11:05:30","slug":"sql-server-2012-new-permissions","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/","title":{"rendered":"SQL Server 2012: new permissions"},"content":{"rendered":"<p>For this end of the year, I decided to present you the new permissions on SQL Server 2012.<\/p>\n<h3>How to have a list of all permissions ?<\/h3>\n<p>It&#8217;s very simple with this query:<\/p>\n<p><samp>SELECT * FROM sys.fn_builtin_permissions(&#8221;)<\/samp><\/p>\n<p style=\"text-align: center\"><strong>SQL 2008 R2<\/strong><br \/>\n<a class=\"easyblog-thumb-preview title=NewPermissionsSQL2008_01.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/NewPermissionsSQL2008_01.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg\" alt=\"\" \/><\/a><\/p>\n<p style=\"text-align: center\"><strong>SQL 2012<\/strong><\/p>\n<p style=\"text-align: center\"><a class=\"easyblog-thumb-preview title=NewPermissionsSQL2012_02.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/NewPermissionsSQL2012_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2012_02.jpg\" alt=\"\" width=\"480\" height=\"400\" \/><\/a><\/p>\n<p>With this comparison, you can see that there are\u00a019 new permissions\u00a0in SQL Server 2012.<br \/>\nTo have a great overview, I prefer use this query ordering by the class description:<\/p>\n<p><samp>SELECT class_desc,count(*) as Permission_Number FROM sys.fn_builtin_permissions(&#8221;) group by class_desc;<\/samp><\/p>\n<p><a class=\"easyblog-thumb-preview title=Class_desc_permission.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Class_desc_permission.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Class_desc_permission.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Just 2 classes have new permissions: SERVER and SCHEMA. But 3 new classes appeared: AVAILABILITY GROUP, SERVER ROLE and SEARCH PROPERTY LIST.<\/p>\n<p>Let&#8217;s go for the details&#8230;<\/p>\n<h3>Class SERVER<\/h3>\n<p>Query:<\/p>\n<p><samp>SELECT * FROM sys.fn_builtin_permissions(&#8221;) where class_desc=&#8217;SERVER&#8217;;<\/samp><\/p>\n<p>Result:<\/p>\n<p><a class=\"easyblog-thumb-preview title=server_permission.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/server_permission.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_server_permission.png\" alt=\"\" width=\"454\" height=\"400\" \/><\/a><\/p>\n<p>These\u00a05 new permissions are for the new features AlwaysOn,\u00a0User-Defined Server Role and Extended Events.<\/p>\n<h3>Class SCHEMA<\/h3>\n<p>Query:<samp>SELECT * FROM sys.fn_builtin_permissions(&#8221;) where class_desc=&#8217;SERVER&#8217;;<\/samp><\/p>\n<p>Result:<\/p>\n<p><a class=\"easyblog-thumb-preview title=Schema_permission.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Schema_permission.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Schema_permission.png\" alt=\"\" width=\"500\" height=\"123\" \/><\/a><\/p>\n<p>This new permission is for the new feature Sequence<\/p>\n<h3>Class AVAILABILITY GROUP<\/h3>\n<p>Query:<samp>SELECT * FROM sys.fn_builtin_permissions(&#8221;) where class_desc=&#8217;AVAILABILITY GROUP&#8217;;<\/samp><\/p>\n<p>Result:<\/p>\n<p><a class=\"easyblog-thumb-preview title=Availability_Group_permission.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Availability_Group_permission.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Availability_Group_permission.png\" alt=\"\" width=\"500\" height=\"46\" \/><\/a><\/p>\n<p>These 4 new permissions are for the new High Availability feature AlwaysOn.<\/p>\n<h3>Class SERVER ROLE<\/h3>\n<p>Query:<samp>SELECT * FROM sys.fn_builtin_permissions(&#8221;) where class_desc=&#8217;SERVER ROLE&#8217;;<\/samp><\/p>\n<p>Result:<\/p>\n<p><a class=\"easyblog-thumb-preview title=Server_Role_permission.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Server_Role_permission.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Server_Role_permission.png\" alt=\"\" width=\"500\" height=\"47\" \/><\/a><\/p>\n<p>These 4 new permissions are for the new feature User defined Server Role.<br \/>\nYou can found an article of this feature <a href=\"\/sql-server-2012-how-to-create-a-server-role\">here<\/a><\/p>\n<h3>Class SEARCH PROPERTIES LIST<\/h3>\n<p>Query:<samp>SELECT * FROM sys.fn_builtin_permissions(&#8221;) where class_desc=&#8217;SEARCH PROPERTIES LIST&#8217;;<\/samp><\/p>\n<p>Result:<\/p>\n<p><a class=\"easyblog-thumb-preview title=Search_Property_List_permission.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Search_Property_List_permission.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Search_Property_List_permission.png\" alt=\"\" width=\"500\" height=\"55\" \/><\/a><\/p>\n<p>These 5 new permissions are for the enhancement of Full-text.<br \/>\nSearch properties list is used to specify one or more search properties that you want to include in a full-text index.<\/p>\n<h3>Conclusion<\/h3>\n<p>19 new permissions for AlwaysOn, Sequence, User-defined Server Role, Extended Event and Search Properties List are created in this version of SQL Server.<\/p>\n<p>This blog is to present you how to find permissions on SQL Server and I hope that can help you.:-D<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For this end of the year, I decided to present you the new permissions on SQL Server 2012. How to have a list of all permissions ? It&#8217;s very simple with this query: SELECT * FROM sys.fn_builtin_permissions(&#8221;) SQL 2008 R2 SQL 2012 With this comparison, you can see that there are\u00a019 new permissions\u00a0in SQL Server&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":2884,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[99],"tags":[49,265,54],"class_list":["post-2883","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-microsoft","tag-sql-server-2008","tag-sql-server-2012"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012: new permissions - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"New permissions are available in SQL Server 2012. How to find it?\" \/>\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.dbi-services.com\/blog\/sql-server-2012-new-permissions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: new permissions\" \/>\n<meta property=\"og:description\" content=\"New permissions are available in SQL Server 2012. How to find it?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-12-24T11:05:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"383\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server 2012: new permissions\",\"datePublished\":\"2012-12-24T11:05:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/\"},\"wordCount\":324,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg\",\"keywords\":[\"Microsoft\",\"SQL Server 2008\",\"SQL Server 2012\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/\",\"name\":\"SQL Server 2012: new permissions - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg\",\"datePublished\":\"2012-12-24T11:05:30+00:00\",\"description\":\"New permissions are available in SQL Server 2012. How to find it?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg\",\"width\":500,\"height\":383},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-permissions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: new permissions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012: new permissions - dbi services | Blog","description":"New permissions are available in SQL Server 2012. How to find it?","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.dbi-services.com\/blog\/sql-server-2012-new-permissions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: new permissions","og_description":"New permissions are available in SQL Server 2012. How to find it?","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2012-12-24T11:05:30+00:00","og_image":[{"width":500,"height":383,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server 2012: new permissions","datePublished":"2012-12-24T11:05:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/"},"wordCount":324,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg","keywords":["Microsoft","SQL Server 2008","SQL Server 2012"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/","name":"SQL Server 2012: new permissions - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg","datePublished":"2012-12-24T11:05:30+00:00","description":"New permissions are available in SQL Server 2012. How to find it?","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_NewPermissionsSQL2008_01.jpg","width":500,"height":383},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-permissions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: new permissions"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2883"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2883\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2884"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}