{"id":698,"date":"2015-02-07T12:18:28","date_gmt":"2015-02-07T10:18:28","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=698"},"modified":"2015-02-07T12:18:28","modified_gmt":"2015-02-07T10:18:28","slug":"drop-failed-for-user-my_user-microsoft-sqlserver-smo","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/drop-failed-for-user-my_user-microsoft-sqlserver-smo\/","title":{"rendered":"Drop failed for User &#8216;my_user&#8217;.  (Microsoft.SqlServer.Smo)"},"content":{"rendered":"<p><strong>Drop failed for User &#8216;my_user&#8217;. \u00a0(Microsoft.SqlServer.Smo)<\/strong><\/p>\n<p><strong>The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)<\/strong><\/p>\n<p>\u00d6nce ilgili Database&#8217;i se\u00e7iyoruz ve <strong>New Query<\/strong> a\u00e7\u0131yoruz.<\/p>\n<p><!--more--><\/p>\n<p><strong>SELECT <\/strong>sc.name<\/p>\n<p><strong>FROM <\/strong>sys.schemas sc<\/p>\n<p><strong>WHERE<\/strong> sc.principal_id = USER_ID(&#8216;<strong>my_user<\/strong>&#8216;)<\/p>\n<p>&nbsp;<\/p>\n<p>Sorgusu ile kullan\u0131c\u0131ya ba\u011fl\u0131 Shema&#8217;lar\u0131 g\u00f6rebilirsiniz ve bu \u015femalar\u0131 ba\u015fka bir kullan\u0131c\u0131ya a\u015fa\u011f\u0131daki sorgular ile aktarman\u0131z gerekmektedir.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>ALTER AUTHORIZATION<\/strong><\/p>\n<p><strong>ON SCHEMA::db_datareader<\/strong><\/p>\n<p><strong>TO dbo<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>ALTER AUTHORIZATION<\/strong><\/p>\n<p><strong>ON SCHEMA::db_datawriter<\/strong><\/p>\n<p><strong>TO dbo<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Bu i\u015flemleri yapt\u0131ktan sonra ba\u011fl\u0131 olan kullan\u0131c\u0131y\u0131 silebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Drop failed for User &#8216;my_user&#8217;. \u00a0(Microsoft.SqlServer.Smo) The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) \u00d6nce ilgili Database&#8217;i se\u00e7iyoruz ve New Query a\u00e7\u0131yoruz.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-698","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=698"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/698\/revisions"}],"predecessor-version":[{"id":699,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/698\/revisions\/699"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}