{"id":6603,"date":"2015-12-24T14:37:04","date_gmt":"2015-12-24T13:37:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/"},"modified":"2015-12-24T14:37:04","modified_gmt":"2015-12-24T13:37:04","slug":"delete-an-orphan-user-database-under-ssisdb","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/","title":{"rendered":"Delete an orphan user-database under SSISDB"},"content":{"rendered":"<p>I post a little tips for orphan database-users that we cannot drop so easily in the SSISDB\u2026<br \/>\nI discovered this by a customer and it was very tricky to find the explanation and the solution.<br \/>\nThis is the reason why I will share it with you\u2026<\/p>\n<p><!--more--><\/p>\n<h3>CONTEXT<\/h3>\n<p>All morning, a policy checks orphan database user on all databases from all instances through the <a title=\"EPM Framework\" href=\"https:\/\/epmframework.codeplex.com\/\" target=\"_blank\">Enterprise Policy Management (EPM) Framework<\/a>.<br \/>\nIf the number of orphan database user is more than 0, I have a failed policy per databases\u2026<br \/>\nFor information, an orphan database user is a database user with no link to a login.<br \/>\nFew weeks ago, I have installed a dedicated server for SSIS with the database SSISDB and this week, the policy failed.<\/p>\n<p>To check if a user is orphan, I run the script from the policy:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM  sys.database_principals a\nLEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid\nWHERE b.sid IS NULL AND   a.type In ('U', 'G') AND   a.principal_id &gt; 4\n\n<\/pre>\n<p>The result is one user-database:<br \/>\n<em>Name: dbi\\orphan_user<br \/>\nType_desc: WINDOWS_USER<br \/>\nDefault_schema_name: dbo<br \/>\n\u2026<\/em><\/p>\n<p>And now, I will delete the orphan database user with the classical DROP command:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [SSISDB]\nDROP USER [dbi\\orphan_user]\nGO<\/pre>\n<p>But I haven&#8217;t a good result for my query \ud83d\ude41<br \/>\nI receive an Error:<\/p>\n<p><em style=\"color: red\">Msg 27226, Level 16, State 1, Procedure ddl_cleanup_object_permissions, Line 16<br \/>\nThe database principal has granted or denied permissions to catalog objects in the database and cannot be dropped<br \/>\nMsg 3609, Level 16, State 2, Line 1<br \/>\nThe transaction ended in the trigger. The batch has been aborted.&#8221;<\/em><\/p>\n<h3>\u00a0STEP 1<\/h3>\n<p>The first Step to analyze this error is to see the trigger &#8220;<strong>ddl_cleanup_object_permissions<\/strong>&#8221; from the Error message:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6225 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser01.png\" alt=\"SSISDB_deleteUser01\" width=\"300\" height=\"186\" \/><\/a><\/p>\n<p>As you can see on the picture, you have in the trigger, 5 views\/tables:<\/p>\n<ul>\n<li>[internal].[object_permissions]\u00a0 &#8211;&gt; view<\/li>\n<li>[internal].[folder_permissions] &#8211;&gt; table<\/li>\n<li>[internal].[project_permissions] &#8211;&gt; table<\/li>\n<li>[internal].[environment_permissions] &#8211;&gt; table<\/li>\n<li>[internal].[operation_permissions] &#8211;&gt; table<\/li>\n<\/ul>\n<p>[internal].[object_permissions]\u00a0 is a view created with the 4 tables\u00a0 [internal].[folder_permissions], [internal].[project_permissions], [internal].[environment_permissions] and [internal].[operation_permissions] linked by \u2018UNION ALL\u2019 commands<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6224 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02.png\" alt=\"SSISDB_deleteUser02\" width=\"300\" height=\"242\" \/><\/a><\/p>\n<p>I will search what permissions have this user.<br \/>\nI create this script to have a view between the Object Type (folder, project, environment or operation), permission associated and the user name:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT  CASE (ObjPerm.object_type) \n                     WHEN 1 THEN 'folder' \n                     WHEN 2 THEN 'project' \n                     WHEN 3 THEN 'environment' \n                     WHEN 4 THEN 'operation' \n              END AS [object_type],\nCASE (ObjPerm.permission_type)\n                     WHEN 1 THEN 'READ' \n                     WHEN 2 THEN 'MODIFY' \n                     WHEN 3 THEN 'EXECUTE' \n                     WHEN 4 THEN 'MANAGE_PERMISSIONS' \n                     WHEN 100 THEN 'CREATE_OBJECTS' \n                     WHEN 101 THEN 'READ_OBJECTS' \n                     WHEN 102 THEN 'MODIFY_OBJECTS' \n                     WHEN 103 THEN 'EXECUTE_OBJECTS' \n                     WHEN 104 THEN 'MANAGE_OBJECT_PERMISSIONS' \nEND AS [permission_description],\nPrinc.Name AS [database_user_name] \nFROM [internal].[object_permissions] ObjPerm \nJOIN sys.server_principals Princ \nON ObjPerm.sid = Princ.sid\nWHERE Princ.Name='dbi\\orphan_user' \nORDER BY [object_type] DESC,[database_user_name],[permission_description]\n\n<\/pre>\n<p>In this case, I have no result&#8230;<\/p>\n<p><a href=\"\/\/msdn.microsoft.com\/en-us\/library\/ff878150.aspx\" target=\"_blank\">MSDN Reference for the object type matrix and the permission matrix in the &#8220;catalog.grant_permission&#8221; webpage<\/a><\/p>\n<h3>STEP 2<\/h3>\n<p>The second step is to verify the specific object permission tables with this script:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\/*Folder Permissions*\/\nSELECT fo.*,p.name\nFROM internal.folder_permissions fo\nINNER JOIN sys.database_principals p on fo.[sid] = p.[sid]\nWHERE p.name = 'dbi\\orphan_user'\n\/*Project Permissions*\/\nSELECT pr.*,p.name\nFROM internal.project_permissions pr\nINNER JOIN sys.database_principals p on pr.[sid] = p.[sid]\nWHERE p.name = 'dbi\\orphan_user'\n\/*Environment Permissions*\/\nSELECT en.*,p.name\nFROM internal.environment_permissions en\nINNER JOIN sys.database_principals p on en.[sid] = p.[sid]\nWHERE p.name = 'dbi\\orphan_user'\n\/*Operation Permissions*\/\nSELECT op.*,p.name\nFROM internal.operation_permissions op\nINNER JOIN sys.database_principals p on op.[sid] = p.[sid]\nWHERE p.name = 'dbi\\orphan_user'\n\n<\/pre>\n<p>Only one return a result. In this case, it is the query with internal.operation_permissions.<br \/>\nI can deduct that I have some &#8220;ghost rows&#8221; in this table.<\/p>\n<h3>STEP 3<\/h3>\n<p>The third step is to delete these \u201cghost rows\u201d but before don\u2019t forget every time to back up the database SSISDB.<br \/>\nThe ugly step is now to delete all rows in the internal.operation_permissions with the orphan user &#8216;dbi\\orphan_user&#8217; I use the sid from the user to delete it<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DELETE internal.operation_permissions WHERE sid = 0x01050000000000051\u2026<\/pre>\n<p>Logically, if you have others rows in the other object types, you can also delete rows.<br \/>\nThe last step is really to drop the database user and now, it works!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I post a little tips for orphan database-users that we cannot drop so easily in the SSISDB\u2026 I discovered this by a customer and it was very tricky to find the explanation and the solution. This is the reason why I will share it with you\u2026<\/p>\n","protected":false},"author":15,"featured_media":6606,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[23,263,49,51,44],"type_dbi":[],"class_list":["post-6603","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-dba","tag-integration-services","tag-microsoft","tag-sql-server","tag-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Delete an orphan user-database under SSISDB<\/title>\n<meta name=\"description\" content=\"How to delete orphan database-users that we cannot drop so easily in the SSISDB....\" \/>\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\/delete-an-orphan-user-database-under-ssisdb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delete an orphan user-database under SSISDB\" \/>\n<meta property=\"og:description\" content=\"How to delete orphan database-users that we cannot drop so easily in the SSISDB....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-24T13:37:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"928\" \/>\n\t<meta property=\"og:image:height\" content=\"748\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"4 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\\\/delete-an-orphan-user-database-under-ssisdb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Delete an orphan user-database under SSISDB\",\"datePublished\":\"2015-12-24T13:37:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/\"},\"wordCount\":505,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"keywords\":[\"DBA\",\"Integration services\",\"Microsoft\",\"SQL Server\",\"Troubleshooting\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/\",\"name\":\"Delete an orphan user-database under SSISDB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"datePublished\":\"2015-12-24T13:37:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"How to delete orphan database-users that we cannot drop so easily in the SSISDB....\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"width\":928,\"height\":748},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delete-an-orphan-user-database-under-ssisdb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delete an orphan user-database under SSISDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Delete an orphan user-database under SSISDB","description":"How to delete orphan database-users that we cannot drop so easily in the SSISDB....","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\/delete-an-orphan-user-database-under-ssisdb\/","og_locale":"en_US","og_type":"article","og_title":"Delete an orphan user-database under SSISDB","og_description":"How to delete orphan database-users that we cannot drop so easily in the SSISDB....","og_url":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/","og_site_name":"dbi Blog","article_published_time":"2015-12-24T13:37:04+00:00","og_image":[{"width":928,"height":748,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Delete an orphan user-database under SSISDB","datePublished":"2015-12-24T13:37:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/"},"wordCount":505,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02-1.png","keywords":["DBA","Integration services","Microsoft","SQL Server","Troubleshooting"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/","url":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/","name":"Delete an orphan user-database under SSISDB","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02-1.png","datePublished":"2015-12-24T13:37:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"How to delete orphan database-users that we cannot drop so easily in the SSISDB....","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSISDB_deleteUser02-1.png","width":928,"height":748},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/delete-an-orphan-user-database-under-ssisdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Delete an orphan user-database under SSISDB"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6603","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=6603"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6603\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6606"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6603"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}