{"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<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\/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\/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\/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\/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 CONTEXT All morning, a policy checks orphan database user&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":6606,"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":[4133],"tags":[23,263,49,44],"class_list":["post-6603","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-dba","tag-integration-services","tag-microsoft","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - 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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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: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=\"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\\\/7980252d7d7a521e285e7c66114cf82a\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"keywords\":[\"DBA\",\"Integration services\",\"Microsoft\",\"Troubleshooting\"],\"articleSection\":[\"Database\"],\"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\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"datePublished\":\"2015-12-24T13:37:04+00:00\",\"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\\\/2022\\\/04\\\/SSISDB_deleteUser02-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"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 specialized 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":"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 services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/SSISDB_deleteUser02-1.png","type":"image\/png"}],"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":"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\/7980252d7d7a521e285e7c66114cf82a"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/2022\/04\/SSISDB_deleteUser02-1.png","keywords":["DBA","Integration services","Microsoft","Troubleshooting"],"articleSection":["Database"],"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\/2022\/04\/SSISDB_deleteUser02-1.png","datePublished":"2015-12-24T13:37:04+00:00","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\/2022\/04\/SSISDB_deleteUser02-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","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 specialized 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\/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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}